/*
 Navicat Premium Data Transfer

 Source Server         : 本地mysql
 Source Server Type    : MySQL
 Source Server Version : 50732
 Source Host           : localhost:3306
 Source Schema         : cup

 Target Server Type    : MySQL
 Target Server Version : 50732
 File Encoding         : 65001

 Date: 12/08/2021 20:36:05
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for act_evt_log
-- ----------------------------
DROP TABLE IF EXISTS `act_evt_log`;
CREATE TABLE `act_evt_log` (
  `LOG_NR_` bigint(20) NOT NULL AUTO_INCREMENT,
  `TYPE_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  `PROC_DEF_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  `PROC_INST_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  `EXECUTION_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  `TASK_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  `TIME_STAMP_` timestamp(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3) ON UPDATE CURRENT_TIMESTAMP(3),
  `USER_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `DATA_` longblob,
  `LOCK_OWNER_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `LOCK_TIME_` timestamp(3) NULL DEFAULT NULL,
  `IS_PROCESSED_` tinyint(4) DEFAULT '0',
  PRIMARY KEY (`LOG_NR_`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

-- ----------------------------
-- Records of act_evt_log
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for act_ge_bytearray
-- ----------------------------
DROP TABLE IF EXISTS `act_ge_bytearray`;
CREATE TABLE `act_ge_bytearray` (
  `ID_` varchar(64) COLLATE utf8_bin NOT NULL,
  `REV_` int(11) DEFAULT NULL,
  `NAME_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `DEPLOYMENT_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  `BYTES_` longblob,
  `GENERATED_` tinyint(4) DEFAULT NULL,
  PRIMARY KEY (`ID_`),
  KEY `ACT_FK_BYTEARR_DEPL` (`DEPLOYMENT_ID_`),
  CONSTRAINT `ACT_FK_BYTEARR_DEPL` FOREIGN KEY (`DEPLOYMENT_ID_`) REFERENCES `act_re_deployment` (`ID_`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

-- ----------------------------
-- Records of act_ge_bytearray
-- ----------------------------
BEGIN;
INSERT INTO `act_ge_bytearray` VALUES ('566e5895-fb36-11eb-8e45-acde48001122', 1, 'userDefineXml.bpmn', '566e5894-fb36-11eb-8e45-acde48001122', 0x3C3F786D6C2076657273696F6E3D22312E302220656E636F64696E673D225554462D38223F3E0A3C62706D6E3A646566696E6974696F6E7320786D6C6E733A7873693D22687474703A2F2F7777772E77332E6F72672F323030312F584D4C536368656D612D696E7374616E63652220786D6C6E733A62706D6E3D22687474703A2F2F7777772E6F6D672E6F72672F737065632F42504D4E2F32303130303532342F4D4F44454C2220786D6C6E733A62706D6E64693D22687474703A2F2F7777772E6F6D672E6F72672F737065632F42504D4E2F32303130303532342F44492220786D6C6E733A64633D22687474703A2F2F7777772E6F6D672E6F72672F737065632F44442F32303130303532342F44432220786D6C6E733A61637469766974693D22687474703A2F2F61637469766974692E6F72672F62706D6E2220786D6C6E733A64693D22687474703A2F2F7777772E6F6D672E6F72672F737065632F44442F32303130303532342F4449222069643D22446566696E6974696F6E735F3122207461726765744E616D6573706163653D22687474703A2F2F62706D6E2E696F2F736368656D612F62706D6E223E0A20203C62706D6E3A70726F636573732069643D2250726F636573735F3122206E616D653D22E6B58BE8AF95E5B7A5E4BD9CE6B5812220697345786563757461626C653D2274727565223E0A202020203C62706D6E3A73746172744576656E742069643D2253746172744576656E745F31223E0A2020202020203C62706D6E3A6F7574676F696E673E466C6F775F317279316737313C2F62706D6E3A6F7574676F696E673E0A202020203C2F62706D6E3A73746172744576656E743E0A202020203C62706D6E3A757365725461736B2069643D2241637469766974795F313276396A306522206E616D653D22E68F90E4BAA4E8AFB7E58187222061637469766974693A61737369676E65653D2261646D696E223E0A2020202020203C62706D6E3A696E636F6D696E673E466C6F775F317279316737313C2F62706D6E3A696E636F6D696E673E0A2020202020203C62706D6E3A6F7574676F696E673E466C6F775F303039686F76303C2F62706D6E3A6F7574676F696E673E0A202020203C2F62706D6E3A757365725461736B3E0A202020203C62706D6E3A73657175656E6365466C6F772069643D22466C6F775F317279316737312220736F757263655265663D2253746172744576656E745F3122207461726765745265663D2241637469766974795F313276396A306522202F3E0A202020203C62706D6E3A757365725461736B2069643D2241637469766974795F307A6572766B6222206E616D653D22E7BB8FE79086E5AEA1E689B9222061637469766974693A61737369676E65653D2261646D696E223E0A2020202020203C62706D6E3A696E636F6D696E673E466C6F775F303039686F76303C2F62706D6E3A696E636F6D696E673E0A2020202020203C62706D6E3A6F7574676F696E673E466C6F775F316976383333343C2F62706D6E3A6F7574676F696E673E0A202020203C2F62706D6E3A757365725461736B3E0A202020203C62706D6E3A73657175656E6365466C6F772069643D22466C6F775F303039686F76302220736F757263655265663D2241637469766974795F313276396A306522207461726765745265663D2241637469766974795F307A6572766B6222202F3E0A202020203C62706D6E3A656E644576656E742069643D224576656E745F306B6471757734223E0A2020202020203C62706D6E3A696E636F6D696E673E466C6F775F316976383333343C2F62706D6E3A696E636F6D696E673E0A202020203C2F62706D6E3A656E644576656E743E0A202020203C62706D6E3A73657175656E6365466C6F772069643D22466C6F775F316976383333342220736F757263655265663D2241637469766974795F307A6572766B6222207461726765745265663D224576656E745F306B647175773422202F3E0A20203C2F62706D6E3A70726F636573733E0A20203C62706D6E64693A42504D4E4469616772616D2069643D2242504D4E4469616772616D5F31223E0A202020203C62706D6E64693A42504D4E506C616E652069643D2242504D4E506C616E655F31222062706D6E456C656D656E743D2250726F636573735F31223E0A2020202020203C62706D6E64693A42504D4E456467652069643D22466C6F775F317279316737315F6469222062706D6E456C656D656E743D22466C6F775F31727931673731223E0A20202020202020203C64693A776179706F696E7420783D223230392220793D2231323022202F3E0A20202020202020203C64693A776179706F696E7420783D223236302220793D2231323022202F3E0A2020202020203C2F62706D6E64693A42504D4E456467653E0A2020202020203C62706D6E64693A42504D4E456467652069643D22466C6F775F303039686F76305F6469222062706D6E456C656D656E743D22466C6F775F303039686F7630223E0A20202020202020203C64693A776179706F696E7420783D223336302220793D2231323022202F3E0A20202020202020203C64693A776179706F696E7420783D223432302220793D2231323022202F3E0A2020202020203C2F62706D6E64693A42504D4E456467653E0A2020202020203C62706D6E64693A42504D4E456467652069643D22466C6F775F316976383333345F6469222062706D6E456C656D656E743D22466C6F775F31697638333334223E0A20202020202020203C64693A776179706F696E7420783D223532302220793D2231323022202F3E0A20202020202020203C64693A776179706F696E7420783D223538322220793D2231323022202F3E0A2020202020203C2F62706D6E64693A42504D4E456467653E0A2020202020203C62706D6E64693A42504D4E53686170652069643D225F42504D4E53686170655F53746172744576656E745F32222062706D6E456C656D656E743D2253746172744576656E745F31223E0A20202020202020203C64633A426F756E647320783D223137332220793D22313032222077696474683D22333622206865696768743D22333622202F3E0A2020202020203C2F62706D6E64693A42504D4E53686170653E0A2020202020203C62706D6E64693A42504D4E53686170652069643D2241637469766974795F313276396A30655F6469222062706D6E456C656D656E743D2241637469766974795F313276396A3065223E0A20202020202020203C64633A426F756E647320783D223236302220793D223830222077696474683D2231303022206865696768743D22383022202F3E0A2020202020203C2F62706D6E64693A42504D4E53686170653E0A2020202020203C62706D6E64693A42504D4E53686170652069643D2241637469766974795F307A6572766B625F6469222062706D6E456C656D656E743D2241637469766974795F307A6572766B62223E0A20202020202020203C64633A426F756E647320783D223432302220793D223830222077696474683D2231303022206865696768743D22383022202F3E0A2020202020203C2F62706D6E64693A42504D4E53686170653E0A2020202020203C62706D6E64693A42504D4E53686170652069643D224576656E745F306B64717577345F6469222062706D6E456C656D656E743D224576656E745F306B6471757734223E0A20202020202020203C64633A426F756E647320783D223538322220793D22313032222077696474683D22333622206865696768743D22333622202F3E0A2020202020203C2F62706D6E64693A42504D4E53686170653E0A202020203C2F62706D6E64693A42504D4E506C616E653E0A20203C2F62706D6E64693A42504D4E4469616772616D3E0A3C2F62706D6E3A646566696E6974696F6E733E0A, 0);
COMMIT;

-- ----------------------------
-- Table structure for act_ge_property
-- ----------------------------
DROP TABLE IF EXISTS `act_ge_property`;
CREATE TABLE `act_ge_property` (
  `NAME_` varchar(64) COLLATE utf8_bin NOT NULL,
  `VALUE_` varchar(300) COLLATE utf8_bin DEFAULT NULL,
  `REV_` int(11) DEFAULT NULL,
  PRIMARY KEY (`NAME_`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

-- ----------------------------
-- Records of act_ge_property
-- ----------------------------
BEGIN;
INSERT INTO `act_ge_property` VALUES ('cfg.execution-related-entities-count', 'false', 1);
INSERT INTO `act_ge_property` VALUES ('next.dbid', '2501', 2);
INSERT INTO `act_ge_property` VALUES ('schema.history', 'create(7.1.0-M6)', 1);
INSERT INTO `act_ge_property` VALUES ('schema.version', '7.1.0-M6', 1);
COMMIT;

-- ----------------------------
-- Table structure for act_hi_actinst
-- ----------------------------
DROP TABLE IF EXISTS `act_hi_actinst`;
CREATE TABLE `act_hi_actinst` (
  `ID_` varchar(64) COLLATE utf8_bin NOT NULL,
  `PROC_DEF_ID_` varchar(64) COLLATE utf8_bin NOT NULL,
  `PROC_INST_ID_` varchar(64) COLLATE utf8_bin NOT NULL,
  `EXECUTION_ID_` varchar(64) COLLATE utf8_bin NOT NULL,
  `ACT_ID_` varchar(255) COLLATE utf8_bin NOT NULL,
  `TASK_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  `CALL_PROC_INST_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  `ACT_NAME_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `ACT_TYPE_` varchar(255) COLLATE utf8_bin NOT NULL,
  `ASSIGNEE_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `START_TIME_` datetime(3) NOT NULL,
  `END_TIME_` datetime(3) DEFAULT NULL,
  `DURATION_` bigint(20) DEFAULT NULL,
  `DELETE_REASON_` varchar(4000) COLLATE utf8_bin DEFAULT NULL,
  `TENANT_ID_` varchar(255) COLLATE utf8_bin DEFAULT '',
  PRIMARY KEY (`ID_`),
  KEY `ACT_IDX_HI_ACT_INST_START` (`START_TIME_`),
  KEY `ACT_IDX_HI_ACT_INST_END` (`END_TIME_`),
  KEY `ACT_IDX_HI_ACT_INST_PROCINST` (`PROC_INST_ID_`,`ACT_ID_`),
  KEY `ACT_IDX_HI_ACT_INST_EXEC` (`EXECUTION_ID_`,`ACT_ID_`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

-- ----------------------------
-- Records of act_hi_actinst
-- ----------------------------
BEGIN;
INSERT INTO `act_hi_actinst` VALUES ('4', 'Process_1:1:56931ea6-fb36-11eb-8e45-acde48001122', '1', '3', 'StartEvent_1', NULL, NULL, NULL, 'startEvent', NULL, '2021-08-12 14:29:12.028', '2021-08-12 14:29:12.031', 3, NULL, '');
INSERT INTO `act_hi_actinst` VALUES ('5', 'Process_1:1:56931ea6-fb36-11eb-8e45-acde48001122', '1', '3', 'Activity_12v9j0e', '6', NULL, '提交请假', 'userTask', 'admin', '2021-08-12 14:29:12.033', '2021-08-12 14:29:19.326', 7293, NULL, '');
INSERT INTO `act_hi_actinst` VALUES ('9fd627c1-fb36-11eb-b558-acde48001122', 'Process_1:1:56931ea6-fb36-11eb-8e45-acde48001122', '1', '3', 'Activity_0zervkb', '9fd93502-fb36-11eb-b558-acde48001122', NULL, '经理审批', 'userTask', 'admin', '2021-08-12 14:29:19.335', '2021-08-12 14:29:21.980', 2645, NULL, '');
INSERT INTO `act_hi_actinst` VALUES ('a169c016-fb36-11eb-b558-acde48001122', 'Process_1:1:56931ea6-fb36-11eb-8e45-acde48001122', '1', '3', 'Event_0kdquw4', NULL, NULL, NULL, 'endEvent', NULL, '2021-08-12 14:29:21.980', '2021-08-12 14:29:21.980', 0, NULL, '');
COMMIT;

-- ----------------------------
-- Table structure for act_hi_attachment
-- ----------------------------
DROP TABLE IF EXISTS `act_hi_attachment`;
CREATE TABLE `act_hi_attachment` (
  `ID_` varchar(64) COLLATE utf8_bin NOT NULL,
  `REV_` int(11) DEFAULT NULL,
  `USER_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `NAME_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `DESCRIPTION_` varchar(4000) COLLATE utf8_bin DEFAULT NULL,
  `TYPE_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `TASK_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  `PROC_INST_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  `URL_` varchar(4000) COLLATE utf8_bin DEFAULT NULL,
  `CONTENT_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  `TIME_` datetime(3) DEFAULT NULL,
  PRIMARY KEY (`ID_`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

-- ----------------------------
-- Records of act_hi_attachment
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for act_hi_comment
-- ----------------------------
DROP TABLE IF EXISTS `act_hi_comment`;
CREATE TABLE `act_hi_comment` (
  `ID_` varchar(64) COLLATE utf8_bin NOT NULL,
  `TYPE_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `TIME_` datetime(3) NOT NULL,
  `USER_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `TASK_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  `PROC_INST_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  `ACTION_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `MESSAGE_` varchar(4000) COLLATE utf8_bin DEFAULT NULL,
  `FULL_MSG_` longblob,
  PRIMARY KEY (`ID_`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

-- ----------------------------
-- Records of act_hi_comment
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for act_hi_detail
-- ----------------------------
DROP TABLE IF EXISTS `act_hi_detail`;
CREATE TABLE `act_hi_detail` (
  `ID_` varchar(64) COLLATE utf8_bin NOT NULL,
  `TYPE_` varchar(255) COLLATE utf8_bin NOT NULL,
  `PROC_INST_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  `EXECUTION_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  `TASK_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  `ACT_INST_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  `NAME_` varchar(255) COLLATE utf8_bin NOT NULL,
  `VAR_TYPE_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `REV_` int(11) DEFAULT NULL,
  `TIME_` datetime(3) NOT NULL,
  `BYTEARRAY_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  `DOUBLE_` double DEFAULT NULL,
  `LONG_` bigint(20) DEFAULT NULL,
  `TEXT_` varchar(4000) COLLATE utf8_bin DEFAULT NULL,
  `TEXT2_` varchar(4000) COLLATE utf8_bin DEFAULT NULL,
  PRIMARY KEY (`ID_`),
  KEY `ACT_IDX_HI_DETAIL_PROC_INST` (`PROC_INST_ID_`),
  KEY `ACT_IDX_HI_DETAIL_ACT_INST` (`ACT_INST_ID_`),
  KEY `ACT_IDX_HI_DETAIL_TIME` (`TIME_`),
  KEY `ACT_IDX_HI_DETAIL_NAME` (`NAME_`),
  KEY `ACT_IDX_HI_DETAIL_TASK_ID` (`TASK_ID_`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

-- ----------------------------
-- Records of act_hi_detail
-- ----------------------------
BEGIN;
INSERT INTO `act_hi_detail` VALUES ('9fda6d84-fb36-11eb-b558-acde48001122', 'VariableUpdate', '1', '3', '9fd93502-fb36-11eb-b558-acde48001122', NULL, 'day', 'integer', 0, '2021-08-12 14:29:19.363', NULL, NULL, 2, '2', NULL);
INSERT INTO `act_hi_detail` VALUES ('a168d5b5-fb36-11eb-b558-acde48001122', 'VariableUpdate', '1', '1', NULL, NULL, 'day', 'integer', 1, '2021-08-12 14:29:21.974', NULL, NULL, 2, '2', NULL);
COMMIT;

-- ----------------------------
-- Table structure for act_hi_identitylink
-- ----------------------------
DROP TABLE IF EXISTS `act_hi_identitylink`;
CREATE TABLE `act_hi_identitylink` (
  `ID_` varchar(64) COLLATE utf8_bin NOT NULL,
  `GROUP_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `TYPE_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `USER_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `TASK_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  `PROC_INST_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  PRIMARY KEY (`ID_`),
  KEY `ACT_IDX_HI_IDENT_LNK_USER` (`USER_ID_`),
  KEY `ACT_IDX_HI_IDENT_LNK_TASK` (`TASK_ID_`),
  KEY `ACT_IDX_HI_IDENT_LNK_PROCINST` (`PROC_INST_ID_`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

-- ----------------------------
-- Records of act_hi_identitylink
-- ----------------------------
BEGIN;
INSERT INTO `act_hi_identitylink` VALUES ('7', NULL, 'participant', 'admin', NULL, '1');
COMMIT;

-- ----------------------------
-- Table structure for act_hi_procinst
-- ----------------------------
DROP TABLE IF EXISTS `act_hi_procinst`;
CREATE TABLE `act_hi_procinst` (
  `ID_` varchar(64) COLLATE utf8_bin NOT NULL,
  `PROC_INST_ID_` varchar(64) COLLATE utf8_bin NOT NULL,
  `BUSINESS_KEY_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `PROC_DEF_ID_` varchar(64) COLLATE utf8_bin NOT NULL,
  `START_TIME_` datetime(3) NOT NULL,
  `END_TIME_` datetime(3) DEFAULT NULL,
  `DURATION_` bigint(20) DEFAULT NULL,
  `START_USER_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `START_ACT_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `END_ACT_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `SUPER_PROCESS_INSTANCE_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  `DELETE_REASON_` varchar(4000) COLLATE utf8_bin DEFAULT NULL,
  `TENANT_ID_` varchar(255) COLLATE utf8_bin DEFAULT '',
  `NAME_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  PRIMARY KEY (`ID_`),
  UNIQUE KEY `PROC_INST_ID_` (`PROC_INST_ID_`),
  KEY `ACT_IDX_HI_PRO_INST_END` (`END_TIME_`),
  KEY `ACT_IDX_HI_PRO_I_BUSKEY` (`BUSINESS_KEY_`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

-- ----------------------------
-- Records of act_hi_procinst
-- ----------------------------
BEGIN;
INSERT INTO `act_hi_procinst` VALUES ('1', '1', NULL, 'Process_1:1:56931ea6-fb36-11eb-8e45-acde48001122', '2021-08-12 14:29:11.968', '2021-08-12 14:29:22.013', 10045, NULL, 'StartEvent_1', 'Event_0kdquw4', NULL, NULL, '', NULL);
COMMIT;

-- ----------------------------
-- Table structure for act_hi_taskinst
-- ----------------------------
DROP TABLE IF EXISTS `act_hi_taskinst`;
CREATE TABLE `act_hi_taskinst` (
  `ID_` varchar(64) COLLATE utf8_bin NOT NULL,
  `PROC_DEF_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  `TASK_DEF_KEY_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `PROC_INST_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  `EXECUTION_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  `NAME_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `PARENT_TASK_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  `DESCRIPTION_` varchar(4000) COLLATE utf8_bin DEFAULT NULL,
  `OWNER_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `ASSIGNEE_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `START_TIME_` datetime(3) NOT NULL,
  `CLAIM_TIME_` datetime(3) DEFAULT NULL,
  `END_TIME_` datetime(3) DEFAULT NULL,
  `DURATION_` bigint(20) DEFAULT NULL,
  `DELETE_REASON_` varchar(4000) COLLATE utf8_bin DEFAULT NULL,
  `PRIORITY_` int(11) DEFAULT NULL,
  `DUE_DATE_` datetime(3) DEFAULT NULL,
  `FORM_KEY_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `CATEGORY_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `TENANT_ID_` varchar(255) COLLATE utf8_bin DEFAULT '',
  PRIMARY KEY (`ID_`),
  KEY `ACT_IDX_HI_TASK_INST_PROCINST` (`PROC_INST_ID_`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

-- ----------------------------
-- Records of act_hi_taskinst
-- ----------------------------
BEGIN;
INSERT INTO `act_hi_taskinst` VALUES ('6', 'Process_1:1:56931ea6-fb36-11eb-8e45-acde48001122', 'Activity_12v9j0e', '1', '3', '提交请假', NULL, NULL, NULL, 'admin', '2021-08-12 14:29:12.058', NULL, '2021-08-12 14:29:19.301', 7243, NULL, 50, NULL, NULL, NULL, '');
INSERT INTO `act_hi_taskinst` VALUES ('9fd93502-fb36-11eb-b558-acde48001122', 'Process_1:1:56931ea6-fb36-11eb-8e45-acde48001122', 'Activity_0zervkb', '1', '3', '经理审批', NULL, NULL, NULL, 'admin', '2021-08-12 14:29:19.355', NULL, '2021-08-12 14:29:21.966', 2611, NULL, 50, NULL, NULL, NULL, '');
COMMIT;

-- ----------------------------
-- Table structure for act_hi_varinst
-- ----------------------------
DROP TABLE IF EXISTS `act_hi_varinst`;
CREATE TABLE `act_hi_varinst` (
  `ID_` varchar(64) COLLATE utf8_bin NOT NULL,
  `PROC_INST_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  `EXECUTION_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  `TASK_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  `NAME_` varchar(255) COLLATE utf8_bin NOT NULL,
  `VAR_TYPE_` varchar(100) COLLATE utf8_bin DEFAULT NULL,
  `REV_` int(11) DEFAULT NULL,
  `BYTEARRAY_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  `DOUBLE_` double DEFAULT NULL,
  `LONG_` bigint(20) DEFAULT NULL,
  `TEXT_` varchar(4000) COLLATE utf8_bin DEFAULT NULL,
  `TEXT2_` varchar(4000) COLLATE utf8_bin DEFAULT NULL,
  `CREATE_TIME_` datetime(3) DEFAULT NULL,
  `LAST_UPDATED_TIME_` datetime(3) DEFAULT NULL,
  PRIMARY KEY (`ID_`),
  KEY `ACT_IDX_HI_PROCVAR_PROC_INST` (`PROC_INST_ID_`),
  KEY `ACT_IDX_HI_PROCVAR_NAME_TYPE` (`NAME_`,`VAR_TYPE_`),
  KEY `ACT_IDX_HI_PROCVAR_TASK_ID` (`TASK_ID_`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

-- ----------------------------
-- Records of act_hi_varinst
-- ----------------------------
BEGIN;
INSERT INTO `act_hi_varinst` VALUES ('2', '1', '1', NULL, 'day', 'integer', 1, NULL, NULL, 2, '2', NULL, '2021-08-12 14:29:12.024', '2021-08-12 14:29:21.977');
INSERT INTO `act_hi_varinst` VALUES ('9fda4673-fb36-11eb-b558-acde48001122', '1', '3', '9fd93502-fb36-11eb-b558-acde48001122', 'day', 'integer', 0, NULL, NULL, 2, '2', NULL, '2021-08-12 14:29:19.362', '2021-08-12 14:29:19.362');
COMMIT;

-- ----------------------------
-- Table structure for act_procdef_info
-- ----------------------------
DROP TABLE IF EXISTS `act_procdef_info`;
CREATE TABLE `act_procdef_info` (
  `ID_` varchar(64) COLLATE utf8_bin NOT NULL,
  `PROC_DEF_ID_` varchar(64) COLLATE utf8_bin NOT NULL,
  `REV_` int(11) DEFAULT NULL,
  `INFO_JSON_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  PRIMARY KEY (`ID_`),
  UNIQUE KEY `ACT_UNIQ_INFO_PROCDEF` (`PROC_DEF_ID_`),
  KEY `ACT_IDX_INFO_PROCDEF` (`PROC_DEF_ID_`),
  KEY `ACT_FK_INFO_JSON_BA` (`INFO_JSON_ID_`),
  CONSTRAINT `ACT_FK_INFO_JSON_BA` FOREIGN KEY (`INFO_JSON_ID_`) REFERENCES `act_ge_bytearray` (`ID_`),
  CONSTRAINT `ACT_FK_INFO_PROCDEF` FOREIGN KEY (`PROC_DEF_ID_`) REFERENCES `act_re_procdef` (`ID_`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

-- ----------------------------
-- Records of act_procdef_info
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for act_re_deployment
-- ----------------------------
DROP TABLE IF EXISTS `act_re_deployment`;
CREATE TABLE `act_re_deployment` (
  `ID_` varchar(64) COLLATE utf8_bin NOT NULL,
  `NAME_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `CATEGORY_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `KEY_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `TENANT_ID_` varchar(255) COLLATE utf8_bin DEFAULT '',
  `DEPLOY_TIME_` timestamp(3) NULL DEFAULT NULL,
  `ENGINE_VERSION_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `VERSION_` int(11) DEFAULT '1',
  `PROJECT_RELEASE_VERSION_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  PRIMARY KEY (`ID_`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

-- ----------------------------
-- Records of act_re_deployment
-- ----------------------------
BEGIN;
INSERT INTO `act_re_deployment` VALUES ('074f462e-fb60-11eb-9023-acde48001122', 'SpringAutoDeployment', NULL, NULL, '', '2021-08-12 19:25:42.281', NULL, 23, NULL);
INSERT INTO `act_re_deployment` VALUES ('098cef3a-fb62-11eb-b154-acde48001122', 'SpringAutoDeployment', NULL, NULL, '', '2021-08-12 19:40:05.031', NULL, 28, NULL);
INSERT INTO `act_re_deployment` VALUES ('0d2a0645-fb52-11eb-858a-acde48001122', 'SpringAutoDeployment', NULL, NULL, '', '2021-08-12 17:45:39.112', NULL, 8, NULL);
INSERT INTO `act_re_deployment` VALUES ('0f18abb5-fb5c-11eb-a145-acde48001122', 'SpringAutoDeployment', NULL, NULL, '', '2021-08-12 18:57:17.366', NULL, 14, NULL);
INSERT INTO `act_re_deployment` VALUES ('12608de8-fb5d-11eb-b588-acde48001122', 'SpringAutoDeployment', NULL, NULL, '', '2021-08-12 19:04:32.335', NULL, 17, NULL);
INSERT INTO `act_re_deployment` VALUES ('1567612b-fb64-11eb-8ce0-acde48001122', 'SpringAutoDeployment', NULL, NULL, '', '2021-08-12 19:54:43.913', NULL, 31, NULL);
INSERT INTO `act_re_deployment` VALUES ('263295bc-fb65-11eb-92fe-acde48001122', 'SpringAutoDeployment', NULL, NULL, '', '2021-08-12 20:02:21.510', NULL, 34, NULL);
INSERT INTO `act_re_deployment` VALUES ('273f0b34-fb5f-11eb-81d0-acde48001122', 'SpringAutoDeployment', NULL, NULL, '', '2021-08-12 19:19:26.370', NULL, 20, NULL);
INSERT INTO `act_re_deployment` VALUES ('3d086168-fb65-11eb-925c-acde48001122', 'SpringAutoDeployment', NULL, NULL, '', '2021-08-12 20:02:59.899', NULL, 35, NULL);
INSERT INTO `act_re_deployment` VALUES ('3eb9de4c-fb61-11eb-b5d0-acde48001122', 'SpringAutoDeployment', NULL, NULL, '', '2021-08-12 19:34:24.742', NULL, 25, NULL);
INSERT INTO `act_re_deployment` VALUES ('3ffcf80a-fb5f-11eb-b297-acde48001122', 'SpringAutoDeployment', NULL, NULL, '', '2021-08-12 19:20:07.829', NULL, 21, NULL);
INSERT INTO `act_re_deployment` VALUES ('41474f61-fb5b-11eb-befa-acde48001122', 'SpringAutoDeployment', NULL, NULL, '', '2021-08-12 18:51:32.028', NULL, 12, NULL);
INSERT INTO `act_re_deployment` VALUES ('4523d665-fb64-11eb-bbd0-acde48001122', 'SpringAutoDeployment', NULL, NULL, '', '2021-08-12 19:56:03.962', NULL, 32, NULL);
INSERT INTO `act_re_deployment` VALUES ('566e5894-fb36-11eb-8e45-acde48001122', 'xml流程20210812142716', NULL, NULL, '', '2021-08-12 14:27:16.180', NULL, 1, NULL);
INSERT INTO `act_re_deployment` VALUES ('570dbcc0-fb52-11eb-bebc-acde48001122', 'SpringAutoDeployment', NULL, NULL, '', '2021-08-12 17:47:43.091', NULL, 9, NULL);
INSERT INTO `act_re_deployment` VALUES ('71ef0021-fb61-11eb-ade0-acde48001122', 'SpringAutoDeployment', NULL, NULL, '', '2021-08-12 19:35:50.639', NULL, 26, NULL);
INSERT INTO `act_re_deployment` VALUES ('74efd669-fb5c-11eb-bdfc-acde48001122', 'SpringAutoDeployment', NULL, NULL, '', '2021-08-12 19:00:08.223', NULL, 15, NULL);
INSERT INTO `act_re_deployment` VALUES ('76183eb4-fb5e-11eb-9804-acde48001122', 'SpringAutoDeployment', NULL, NULL, '', '2021-08-12 19:14:29.160', NULL, 18, NULL);
INSERT INTO `act_re_deployment` VALUES ('7a4a6696-fb4a-11eb-a7c7-acde48001122', 'SpringAutoDeployment', NULL, NULL, '', '2021-08-12 16:51:26.241', NULL, 3, NULL);
INSERT INTO `act_re_deployment` VALUES ('7dbd5376-fb5a-11eb-bfd0-acde48001122', 'SpringAutoDeployment', NULL, NULL, '', '2021-08-12 18:46:03.939', NULL, 11, NULL);
INSERT INTO `act_re_deployment` VALUES ('7f99d31e-fb68-11eb-bad3-acde48001122', 'SpringAutoDeployment', NULL, NULL, '', '2021-08-12 20:26:20.042', NULL, 36, NULL);
INSERT INTO `act_re_deployment` VALUES ('85ebf060-fb36-11eb-b558-acde48001122', 'SpringAutoDeployment', NULL, NULL, '', '2021-08-12 14:28:35.846', NULL, 2, NULL);
INSERT INTO `act_re_deployment` VALUES ('8fd83f32-fb63-11eb-81b4-acde48001122', 'SpringAutoDeployment', NULL, NULL, '', '2021-08-12 19:50:59.586', NULL, 30, NULL);
INSERT INTO `act_re_deployment` VALUES ('948c1b2a-fb4f-11eb-9345-acde48001122', 'SpringAutoDeployment', NULL, NULL, '', '2021-08-12 17:27:57.789', NULL, 5, NULL);
INSERT INTO `act_re_deployment` VALUES ('97c49dbf-fb5c-11eb-b645-acde48001122', 'SpringAutoDeployment', NULL, NULL, '', '2021-08-12 19:01:06.661', NULL, 16, NULL);
INSERT INTO `act_re_deployment` VALUES ('a4ca15a0-fb4e-11eb-83f5-acde48001122', 'SpringAutoDeployment', NULL, NULL, '', '2021-08-12 17:21:15.541', NULL, 4, NULL);
INSERT INTO `act_re_deployment` VALUES ('a5a89f94-fb57-11eb-af62-acde48001122', 'SpringAutoDeployment', NULL, NULL, '', '2021-08-12 18:25:42.446', NULL, 10, NULL);
INSERT INTO `act_re_deployment` VALUES ('af688004-fb62-11eb-b82d-acde48001122', 'SpringAutoDeployment', NULL, NULL, '', '2021-08-12 19:44:43.294', NULL, 29, NULL);
INSERT INTO `act_re_deployment` VALUES ('b7695076-fb5b-11eb-ae5c-acde48001122', 'SpringAutoDeployment', NULL, NULL, '', '2021-08-12 18:54:50.211', NULL, 13, NULL);
INSERT INTO `act_re_deployment` VALUES ('c0cac0b3-fb5f-11eb-b4a5-acde48001122', 'SpringAutoDeployment', NULL, NULL, '', '2021-08-12 19:23:43.872', NULL, 22, NULL);
INSERT INTO `act_re_deployment` VALUES ('c2e17957-fb64-11eb-9841-acde48001122', 'SpringAutoDeployment', NULL, NULL, '', '2021-08-12 19:59:34.808', NULL, 33, NULL);
INSERT INTO `act_re_deployment` VALUES ('d1282806-fb4f-11eb-932d-acde48001122', 'SpringAutoDeployment', NULL, NULL, '', '2021-08-12 17:29:39.468', NULL, 6, NULL);
INSERT INTO `act_re_deployment` VALUES ('d5cdd2ca-fb60-11eb-86be-acde48001122', 'SpringAutoDeployment', NULL, NULL, '', '2021-08-12 19:31:28.721', NULL, 24, NULL);
INSERT INTO `act_re_deployment` VALUES ('e255df47-fb61-11eb-ad2e-acde48001122', 'SpringAutoDeployment', NULL, NULL, '', '2021-08-12 19:38:59.241', NULL, 27, NULL);
INSERT INTO `act_re_deployment` VALUES ('e92f5c92-fb51-11eb-bc2a-acde48001122', 'SpringAutoDeployment', NULL, NULL, '', '2021-08-12 17:44:38.769', NULL, 7, NULL);
INSERT INTO `act_re_deployment` VALUES ('ec92999b-fb5e-11eb-9344-acde48001122', 'SpringAutoDeployment', NULL, NULL, '', '2021-08-12 19:17:47.913', NULL, 19, NULL);
INSERT INTO `act_re_deployment` VALUES ('f0a3ff13-fb35-11eb-8e45-acde48001122', 'SpringAutoDeployment', NULL, NULL, '', '2021-08-12 14:24:25.401', NULL, 1, NULL);
COMMIT;

-- ----------------------------
-- Table structure for act_re_model
-- ----------------------------
DROP TABLE IF EXISTS `act_re_model`;
CREATE TABLE `act_re_model` (
  `ID_` varchar(64) COLLATE utf8_bin NOT NULL,
  `REV_` int(11) DEFAULT NULL,
  `NAME_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `KEY_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `CATEGORY_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `CREATE_TIME_` timestamp(3) NULL DEFAULT NULL,
  `LAST_UPDATE_TIME_` timestamp(3) NULL DEFAULT NULL,
  `VERSION_` int(11) DEFAULT NULL,
  `META_INFO_` varchar(4000) COLLATE utf8_bin DEFAULT NULL,
  `DEPLOYMENT_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  `EDITOR_SOURCE_VALUE_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  `EDITOR_SOURCE_EXTRA_VALUE_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  `TENANT_ID_` varchar(255) COLLATE utf8_bin DEFAULT '',
  PRIMARY KEY (`ID_`),
  KEY `ACT_FK_MODEL_SOURCE` (`EDITOR_SOURCE_VALUE_ID_`),
  KEY `ACT_FK_MODEL_SOURCE_EXTRA` (`EDITOR_SOURCE_EXTRA_VALUE_ID_`),
  KEY `ACT_FK_MODEL_DEPLOYMENT` (`DEPLOYMENT_ID_`),
  CONSTRAINT `ACT_FK_MODEL_DEPLOYMENT` FOREIGN KEY (`DEPLOYMENT_ID_`) REFERENCES `act_re_deployment` (`ID_`),
  CONSTRAINT `ACT_FK_MODEL_SOURCE` FOREIGN KEY (`EDITOR_SOURCE_VALUE_ID_`) REFERENCES `act_ge_bytearray` (`ID_`),
  CONSTRAINT `ACT_FK_MODEL_SOURCE_EXTRA` FOREIGN KEY (`EDITOR_SOURCE_EXTRA_VALUE_ID_`) REFERENCES `act_ge_bytearray` (`ID_`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

-- ----------------------------
-- Records of act_re_model
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for act_re_procdef
-- ----------------------------
DROP TABLE IF EXISTS `act_re_procdef`;
CREATE TABLE `act_re_procdef` (
  `ID_` varchar(64) COLLATE utf8_bin NOT NULL,
  `REV_` int(11) DEFAULT NULL,
  `CATEGORY_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `NAME_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `KEY_` varchar(255) COLLATE utf8_bin NOT NULL,
  `VERSION_` int(11) NOT NULL,
  `DEPLOYMENT_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  `RESOURCE_NAME_` varchar(4000) COLLATE utf8_bin DEFAULT NULL,
  `DGRM_RESOURCE_NAME_` varchar(4000) COLLATE utf8_bin DEFAULT NULL,
  `DESCRIPTION_` varchar(4000) COLLATE utf8_bin DEFAULT NULL,
  `HAS_START_FORM_KEY_` tinyint(4) DEFAULT NULL,
  `HAS_GRAPHICAL_NOTATION_` tinyint(4) DEFAULT NULL,
  `SUSPENSION_STATE_` int(11) DEFAULT NULL,
  `TENANT_ID_` varchar(255) COLLATE utf8_bin DEFAULT '',
  `ENGINE_VERSION_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `APP_VERSION_` int(11) DEFAULT NULL,
  PRIMARY KEY (`ID_`),
  UNIQUE KEY `ACT_UNIQ_PROCDEF` (`KEY_`,`VERSION_`,`TENANT_ID_`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

-- ----------------------------
-- Records of act_re_procdef
-- ----------------------------
BEGIN;
INSERT INTO `act_re_procdef` VALUES ('Process_1:1:56931ea6-fb36-11eb-8e45-acde48001122', 3, 'http://bpmn.io/schema/bpmn', '测试工作流', 'Process_1', 1, '566e5894-fb36-11eb-8e45-acde48001122', 'userDefineXml.bpmn', NULL, NULL, 0, 1, 1, '', NULL, NULL);
COMMIT;

-- ----------------------------
-- Table structure for act_ru_deadletter_job
-- ----------------------------
DROP TABLE IF EXISTS `act_ru_deadletter_job`;
CREATE TABLE `act_ru_deadletter_job` (
  `ID_` varchar(64) COLLATE utf8_bin NOT NULL,
  `REV_` int(11) DEFAULT NULL,
  `TYPE_` varchar(255) COLLATE utf8_bin NOT NULL,
  `EXCLUSIVE_` tinyint(1) DEFAULT NULL,
  `EXECUTION_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  `PROCESS_INSTANCE_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  `PROC_DEF_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  `EXCEPTION_STACK_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  `EXCEPTION_MSG_` varchar(4000) COLLATE utf8_bin DEFAULT NULL,
  `DUEDATE_` timestamp(3) NULL DEFAULT NULL,
  `REPEAT_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `HANDLER_TYPE_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `HANDLER_CFG_` varchar(4000) COLLATE utf8_bin DEFAULT NULL,
  `TENANT_ID_` varchar(255) COLLATE utf8_bin DEFAULT '',
  PRIMARY KEY (`ID_`),
  KEY `ACT_FK_DEADLETTER_JOB_EXECUTION` (`EXECUTION_ID_`),
  KEY `ACT_FK_DEADLETTER_JOB_PROCESS_INSTANCE` (`PROCESS_INSTANCE_ID_`),
  KEY `ACT_FK_DEADLETTER_JOB_PROC_DEF` (`PROC_DEF_ID_`),
  KEY `ACT_FK_DEADLETTER_JOB_EXCEPTION` (`EXCEPTION_STACK_ID_`),
  CONSTRAINT `ACT_FK_DEADLETTER_JOB_EXCEPTION` FOREIGN KEY (`EXCEPTION_STACK_ID_`) REFERENCES `act_ge_bytearray` (`ID_`),
  CONSTRAINT `ACT_FK_DEADLETTER_JOB_EXECUTION` FOREIGN KEY (`EXECUTION_ID_`) REFERENCES `act_ru_execution` (`ID_`),
  CONSTRAINT `ACT_FK_DEADLETTER_JOB_PROCESS_INSTANCE` FOREIGN KEY (`PROCESS_INSTANCE_ID_`) REFERENCES `act_ru_execution` (`ID_`),
  CONSTRAINT `ACT_FK_DEADLETTER_JOB_PROC_DEF` FOREIGN KEY (`PROC_DEF_ID_`) REFERENCES `act_re_procdef` (`ID_`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

-- ----------------------------
-- Records of act_ru_deadletter_job
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for act_ru_event_subscr
-- ----------------------------
DROP TABLE IF EXISTS `act_ru_event_subscr`;
CREATE TABLE `act_ru_event_subscr` (
  `ID_` varchar(64) COLLATE utf8_bin NOT NULL,
  `REV_` int(11) DEFAULT NULL,
  `EVENT_TYPE_` varchar(255) COLLATE utf8_bin NOT NULL,
  `EVENT_NAME_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `EXECUTION_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  `PROC_INST_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  `ACTIVITY_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  `CONFIGURATION_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `CREATED_` timestamp(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3),
  `PROC_DEF_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  `TENANT_ID_` varchar(255) COLLATE utf8_bin DEFAULT '',
  PRIMARY KEY (`ID_`),
  KEY `ACT_IDX_EVENT_SUBSCR_CONFIG_` (`CONFIGURATION_`),
  KEY `ACT_FK_EVENT_EXEC` (`EXECUTION_ID_`),
  CONSTRAINT `ACT_FK_EVENT_EXEC` FOREIGN KEY (`EXECUTION_ID_`) REFERENCES `act_ru_execution` (`ID_`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

-- ----------------------------
-- Records of act_ru_event_subscr
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for act_ru_execution
-- ----------------------------
DROP TABLE IF EXISTS `act_ru_execution`;
CREATE TABLE `act_ru_execution` (
  `ID_` varchar(64) COLLATE utf8_bin NOT NULL,
  `REV_` int(11) DEFAULT NULL,
  `PROC_INST_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  `BUSINESS_KEY_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `PARENT_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  `PROC_DEF_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  `SUPER_EXEC_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  `ROOT_PROC_INST_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  `ACT_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `IS_ACTIVE_` tinyint(4) DEFAULT NULL,
  `IS_CONCURRENT_` tinyint(4) DEFAULT NULL,
  `IS_SCOPE_` tinyint(4) DEFAULT NULL,
  `IS_EVENT_SCOPE_` tinyint(4) DEFAULT NULL,
  `IS_MI_ROOT_` tinyint(4) DEFAULT NULL,
  `SUSPENSION_STATE_` int(11) DEFAULT NULL,
  `CACHED_ENT_STATE_` int(11) DEFAULT NULL,
  `TENANT_ID_` varchar(255) COLLATE utf8_bin DEFAULT '',
  `NAME_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `START_TIME_` datetime(3) DEFAULT NULL,
  `START_USER_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `LOCK_TIME_` timestamp(3) NULL DEFAULT NULL,
  `IS_COUNT_ENABLED_` tinyint(4) DEFAULT NULL,
  `EVT_SUBSCR_COUNT_` int(11) DEFAULT NULL,
  `TASK_COUNT_` int(11) DEFAULT NULL,
  `JOB_COUNT_` int(11) DEFAULT NULL,
  `TIMER_JOB_COUNT_` int(11) DEFAULT NULL,
  `SUSP_JOB_COUNT_` int(11) DEFAULT NULL,
  `DEADLETTER_JOB_COUNT_` int(11) DEFAULT NULL,
  `VAR_COUNT_` int(11) DEFAULT NULL,
  `ID_LINK_COUNT_` int(11) DEFAULT NULL,
  `APP_VERSION_` int(11) DEFAULT NULL,
  PRIMARY KEY (`ID_`),
  KEY `ACT_IDX_EXEC_BUSKEY` (`BUSINESS_KEY_`),
  KEY `ACT_IDC_EXEC_ROOT` (`ROOT_PROC_INST_ID_`),
  KEY `ACT_FK_EXE_PROCINST` (`PROC_INST_ID_`),
  KEY `ACT_FK_EXE_PARENT` (`PARENT_ID_`),
  KEY `ACT_FK_EXE_SUPER` (`SUPER_EXEC_`),
  KEY `ACT_FK_EXE_PROCDEF` (`PROC_DEF_ID_`),
  CONSTRAINT `ACT_FK_EXE_PARENT` FOREIGN KEY (`PARENT_ID_`) REFERENCES `act_ru_execution` (`ID_`) ON DELETE CASCADE,
  CONSTRAINT `ACT_FK_EXE_PROCDEF` FOREIGN KEY (`PROC_DEF_ID_`) REFERENCES `act_re_procdef` (`ID_`),
  CONSTRAINT `ACT_FK_EXE_PROCINST` FOREIGN KEY (`PROC_INST_ID_`) REFERENCES `act_ru_execution` (`ID_`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `ACT_FK_EXE_SUPER` FOREIGN KEY (`SUPER_EXEC_`) REFERENCES `act_ru_execution` (`ID_`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

-- ----------------------------
-- Records of act_ru_execution
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for act_ru_identitylink
-- ----------------------------
DROP TABLE IF EXISTS `act_ru_identitylink`;
CREATE TABLE `act_ru_identitylink` (
  `ID_` varchar(64) COLLATE utf8_bin NOT NULL,
  `REV_` int(11) DEFAULT NULL,
  `GROUP_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `TYPE_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `USER_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `TASK_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  `PROC_INST_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  `PROC_DEF_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  PRIMARY KEY (`ID_`),
  KEY `ACT_IDX_IDENT_LNK_USER` (`USER_ID_`),
  KEY `ACT_IDX_IDENT_LNK_GROUP` (`GROUP_ID_`),
  KEY `ACT_IDX_ATHRZ_PROCEDEF` (`PROC_DEF_ID_`),
  KEY `ACT_FK_TSKASS_TASK` (`TASK_ID_`),
  KEY `ACT_FK_IDL_PROCINST` (`PROC_INST_ID_`),
  CONSTRAINT `ACT_FK_ATHRZ_PROCEDEF` FOREIGN KEY (`PROC_DEF_ID_`) REFERENCES `act_re_procdef` (`ID_`),
  CONSTRAINT `ACT_FK_IDL_PROCINST` FOREIGN KEY (`PROC_INST_ID_`) REFERENCES `act_ru_execution` (`ID_`),
  CONSTRAINT `ACT_FK_TSKASS_TASK` FOREIGN KEY (`TASK_ID_`) REFERENCES `act_ru_task` (`ID_`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

-- ----------------------------
-- Records of act_ru_identitylink
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for act_ru_integration
-- ----------------------------
DROP TABLE IF EXISTS `act_ru_integration`;
CREATE TABLE `act_ru_integration` (
  `ID_` varchar(64) COLLATE utf8_bin NOT NULL,
  `EXECUTION_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  `PROCESS_INSTANCE_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  `PROC_DEF_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  `FLOW_NODE_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  `CREATED_DATE_` timestamp(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3) ON UPDATE CURRENT_TIMESTAMP(3),
  PRIMARY KEY (`ID_`),
  KEY `ACT_FK_INT_EXECUTION` (`EXECUTION_ID_`),
  KEY `ACT_FK_INT_PROC_INST` (`PROCESS_INSTANCE_ID_`),
  KEY `ACT_FK_INT_PROC_DEF` (`PROC_DEF_ID_`),
  CONSTRAINT `ACT_FK_INT_EXECUTION` FOREIGN KEY (`EXECUTION_ID_`) REFERENCES `act_ru_execution` (`ID_`) ON DELETE CASCADE,
  CONSTRAINT `ACT_FK_INT_PROC_DEF` FOREIGN KEY (`PROC_DEF_ID_`) REFERENCES `act_re_procdef` (`ID_`),
  CONSTRAINT `ACT_FK_INT_PROC_INST` FOREIGN KEY (`PROCESS_INSTANCE_ID_`) REFERENCES `act_ru_execution` (`ID_`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

-- ----------------------------
-- Records of act_ru_integration
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for act_ru_job
-- ----------------------------
DROP TABLE IF EXISTS `act_ru_job`;
CREATE TABLE `act_ru_job` (
  `ID_` varchar(64) COLLATE utf8_bin NOT NULL,
  `REV_` int(11) DEFAULT NULL,
  `TYPE_` varchar(255) COLLATE utf8_bin NOT NULL,
  `LOCK_EXP_TIME_` timestamp(3) NULL DEFAULT NULL,
  `LOCK_OWNER_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `EXCLUSIVE_` tinyint(1) DEFAULT NULL,
  `EXECUTION_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  `PROCESS_INSTANCE_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  `PROC_DEF_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  `RETRIES_` int(11) DEFAULT NULL,
  `EXCEPTION_STACK_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  `EXCEPTION_MSG_` varchar(4000) COLLATE utf8_bin DEFAULT NULL,
  `DUEDATE_` timestamp(3) NULL DEFAULT NULL,
  `REPEAT_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `HANDLER_TYPE_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `HANDLER_CFG_` varchar(4000) COLLATE utf8_bin DEFAULT NULL,
  `TENANT_ID_` varchar(255) COLLATE utf8_bin DEFAULT '',
  PRIMARY KEY (`ID_`),
  KEY `ACT_FK_JOB_EXECUTION` (`EXECUTION_ID_`),
  KEY `ACT_FK_JOB_PROCESS_INSTANCE` (`PROCESS_INSTANCE_ID_`),
  KEY `ACT_FK_JOB_PROC_DEF` (`PROC_DEF_ID_`),
  KEY `ACT_FK_JOB_EXCEPTION` (`EXCEPTION_STACK_ID_`),
  CONSTRAINT `ACT_FK_JOB_EXCEPTION` FOREIGN KEY (`EXCEPTION_STACK_ID_`) REFERENCES `act_ge_bytearray` (`ID_`),
  CONSTRAINT `ACT_FK_JOB_EXECUTION` FOREIGN KEY (`EXECUTION_ID_`) REFERENCES `act_ru_execution` (`ID_`),
  CONSTRAINT `ACT_FK_JOB_PROCESS_INSTANCE` FOREIGN KEY (`PROCESS_INSTANCE_ID_`) REFERENCES `act_ru_execution` (`ID_`),
  CONSTRAINT `ACT_FK_JOB_PROC_DEF` FOREIGN KEY (`PROC_DEF_ID_`) REFERENCES `act_re_procdef` (`ID_`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

-- ----------------------------
-- Records of act_ru_job
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for act_ru_suspended_job
-- ----------------------------
DROP TABLE IF EXISTS `act_ru_suspended_job`;
CREATE TABLE `act_ru_suspended_job` (
  `ID_` varchar(64) COLLATE utf8_bin NOT NULL,
  `REV_` int(11) DEFAULT NULL,
  `TYPE_` varchar(255) COLLATE utf8_bin NOT NULL,
  `EXCLUSIVE_` tinyint(1) DEFAULT NULL,
  `EXECUTION_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  `PROCESS_INSTANCE_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  `PROC_DEF_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  `RETRIES_` int(11) DEFAULT NULL,
  `EXCEPTION_STACK_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  `EXCEPTION_MSG_` varchar(4000) COLLATE utf8_bin DEFAULT NULL,
  `DUEDATE_` timestamp(3) NULL DEFAULT NULL,
  `REPEAT_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `HANDLER_TYPE_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `HANDLER_CFG_` varchar(4000) COLLATE utf8_bin DEFAULT NULL,
  `TENANT_ID_` varchar(255) COLLATE utf8_bin DEFAULT '',
  PRIMARY KEY (`ID_`),
  KEY `ACT_FK_SUSPENDED_JOB_EXECUTION` (`EXECUTION_ID_`),
  KEY `ACT_FK_SUSPENDED_JOB_PROCESS_INSTANCE` (`PROCESS_INSTANCE_ID_`),
  KEY `ACT_FK_SUSPENDED_JOB_PROC_DEF` (`PROC_DEF_ID_`),
  KEY `ACT_FK_SUSPENDED_JOB_EXCEPTION` (`EXCEPTION_STACK_ID_`),
  CONSTRAINT `ACT_FK_SUSPENDED_JOB_EXCEPTION` FOREIGN KEY (`EXCEPTION_STACK_ID_`) REFERENCES `act_ge_bytearray` (`ID_`),
  CONSTRAINT `ACT_FK_SUSPENDED_JOB_EXECUTION` FOREIGN KEY (`EXECUTION_ID_`) REFERENCES `act_ru_execution` (`ID_`),
  CONSTRAINT `ACT_FK_SUSPENDED_JOB_PROCESS_INSTANCE` FOREIGN KEY (`PROCESS_INSTANCE_ID_`) REFERENCES `act_ru_execution` (`ID_`),
  CONSTRAINT `ACT_FK_SUSPENDED_JOB_PROC_DEF` FOREIGN KEY (`PROC_DEF_ID_`) REFERENCES `act_re_procdef` (`ID_`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

-- ----------------------------
-- Records of act_ru_suspended_job
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for act_ru_task
-- ----------------------------
DROP TABLE IF EXISTS `act_ru_task`;
CREATE TABLE `act_ru_task` (
  `ID_` varchar(64) COLLATE utf8_bin NOT NULL,
  `REV_` int(11) DEFAULT NULL,
  `EXECUTION_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  `PROC_INST_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  `PROC_DEF_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  `NAME_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `BUSINESS_KEY_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `PARENT_TASK_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  `DESCRIPTION_` varchar(4000) COLLATE utf8_bin DEFAULT NULL,
  `TASK_DEF_KEY_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `OWNER_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `ASSIGNEE_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `DELEGATION_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  `PRIORITY_` int(11) DEFAULT NULL,
  `CREATE_TIME_` timestamp(3) NULL DEFAULT NULL,
  `DUE_DATE_` datetime(3) DEFAULT NULL,
  `CATEGORY_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `SUSPENSION_STATE_` int(11) DEFAULT NULL,
  `TENANT_ID_` varchar(255) COLLATE utf8_bin DEFAULT '',
  `FORM_KEY_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `CLAIM_TIME_` datetime(3) DEFAULT NULL,
  `APP_VERSION_` int(11) DEFAULT NULL,
  PRIMARY KEY (`ID_`),
  KEY `ACT_IDX_TASK_CREATE` (`CREATE_TIME_`),
  KEY `ACT_FK_TASK_EXE` (`EXECUTION_ID_`),
  KEY `ACT_FK_TASK_PROCINST` (`PROC_INST_ID_`),
  KEY `ACT_FK_TASK_PROCDEF` (`PROC_DEF_ID_`),
  CONSTRAINT `ACT_FK_TASK_EXE` FOREIGN KEY (`EXECUTION_ID_`) REFERENCES `act_ru_execution` (`ID_`),
  CONSTRAINT `ACT_FK_TASK_PROCDEF` FOREIGN KEY (`PROC_DEF_ID_`) REFERENCES `act_re_procdef` (`ID_`),
  CONSTRAINT `ACT_FK_TASK_PROCINST` FOREIGN KEY (`PROC_INST_ID_`) REFERENCES `act_ru_execution` (`ID_`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

-- ----------------------------
-- Records of act_ru_task
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for act_ru_timer_job
-- ----------------------------
DROP TABLE IF EXISTS `act_ru_timer_job`;
CREATE TABLE `act_ru_timer_job` (
  `ID_` varchar(64) COLLATE utf8_bin NOT NULL,
  `REV_` int(11) DEFAULT NULL,
  `TYPE_` varchar(255) COLLATE utf8_bin NOT NULL,
  `LOCK_EXP_TIME_` timestamp(3) NULL DEFAULT NULL,
  `LOCK_OWNER_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `EXCLUSIVE_` tinyint(1) DEFAULT NULL,
  `EXECUTION_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  `PROCESS_INSTANCE_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  `PROC_DEF_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  `RETRIES_` int(11) DEFAULT NULL,
  `EXCEPTION_STACK_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  `EXCEPTION_MSG_` varchar(4000) COLLATE utf8_bin DEFAULT NULL,
  `DUEDATE_` timestamp(3) NULL DEFAULT NULL,
  `REPEAT_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `HANDLER_TYPE_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `HANDLER_CFG_` varchar(4000) COLLATE utf8_bin DEFAULT NULL,
  `TENANT_ID_` varchar(255) COLLATE utf8_bin DEFAULT '',
  PRIMARY KEY (`ID_`),
  KEY `ACT_FK_TIMER_JOB_EXECUTION` (`EXECUTION_ID_`),
  KEY `ACT_FK_TIMER_JOB_PROCESS_INSTANCE` (`PROCESS_INSTANCE_ID_`),
  KEY `ACT_FK_TIMER_JOB_PROC_DEF` (`PROC_DEF_ID_`),
  KEY `ACT_FK_TIMER_JOB_EXCEPTION` (`EXCEPTION_STACK_ID_`),
  CONSTRAINT `ACT_FK_TIMER_JOB_EXCEPTION` FOREIGN KEY (`EXCEPTION_STACK_ID_`) REFERENCES `act_ge_bytearray` (`ID_`),
  CONSTRAINT `ACT_FK_TIMER_JOB_EXECUTION` FOREIGN KEY (`EXECUTION_ID_`) REFERENCES `act_ru_execution` (`ID_`),
  CONSTRAINT `ACT_FK_TIMER_JOB_PROCESS_INSTANCE` FOREIGN KEY (`PROCESS_INSTANCE_ID_`) REFERENCES `act_ru_execution` (`ID_`),
  CONSTRAINT `ACT_FK_TIMER_JOB_PROC_DEF` FOREIGN KEY (`PROC_DEF_ID_`) REFERENCES `act_re_procdef` (`ID_`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

-- ----------------------------
-- Records of act_ru_timer_job
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for act_ru_variable
-- ----------------------------
DROP TABLE IF EXISTS `act_ru_variable`;
CREATE TABLE `act_ru_variable` (
  `ID_` varchar(64) COLLATE utf8_bin NOT NULL,
  `REV_` int(11) DEFAULT NULL,
  `TYPE_` varchar(255) COLLATE utf8_bin NOT NULL,
  `NAME_` varchar(255) COLLATE utf8_bin NOT NULL,
  `EXECUTION_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  `PROC_INST_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  `TASK_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  `BYTEARRAY_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
  `DOUBLE_` double DEFAULT NULL,
  `LONG_` bigint(20) DEFAULT NULL,
  `TEXT_` varchar(4000) COLLATE utf8_bin DEFAULT NULL,
  `TEXT2_` varchar(4000) COLLATE utf8_bin DEFAULT NULL,
  PRIMARY KEY (`ID_`),
  KEY `ACT_IDX_VARIABLE_TASK_ID` (`TASK_ID_`),
  KEY `ACT_FK_VAR_EXE` (`EXECUTION_ID_`),
  KEY `ACT_FK_VAR_PROCINST` (`PROC_INST_ID_`),
  KEY `ACT_FK_VAR_BYTEARRAY` (`BYTEARRAY_ID_`),
  CONSTRAINT `ACT_FK_VAR_BYTEARRAY` FOREIGN KEY (`BYTEARRAY_ID_`) REFERENCES `act_ge_bytearray` (`ID_`),
  CONSTRAINT `ACT_FK_VAR_EXE` FOREIGN KEY (`EXECUTION_ID_`) REFERENCES `act_ru_execution` (`ID_`),
  CONSTRAINT `ACT_FK_VAR_PROCINST` FOREIGN KEY (`PROC_INST_ID_`) REFERENCES `act_ru_execution` (`ID_`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

-- ----------------------------
-- Records of act_ru_variable
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for leave_bill
-- ----------------------------
DROP TABLE IF EXISTS `leave_bill`;
CREATE TABLE `leave_bill` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `user_id` int(11) DEFAULT NULL COMMENT '用户id',
  `type` char(1) DEFAULT NULL COMMENT '请假类型(1.年假2.事假3.病假 4.调休假)',
  `reason` varchar(500) DEFAULT NULL COMMENT '请假原因',
  `start_date` date DEFAULT NULL COMMENT '开始时间',
  `end_date` date DEFAULT NULL COMMENT '结束时间',
  `advise` varchar(500) DEFAULT NULL COMMENT '审批意见',
  `status` char(1) DEFAULT NULL COMMENT '请假状态(0待审核 -1驳回 -2不通过 1通过)',
  `create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  `del_flag` int(11) DEFAULT '0' COMMENT '是否删除,1已删0未删',
  `tenant_id` int(11) DEFAULT '1' COMMENT '租户id',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=30 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='请假单';

-- ----------------------------
-- Records of leave_bill
-- ----------------------------
BEGIN;
INSERT INTO `leave_bill` VALUES (28, 9, '2', '我要请假', '2021-08-02', '2021-08-06', NULL, '0', '2021-08-02 16:18:50', '2021-08-12 14:40:01', 0, 1);
COMMIT;

-- ----------------------------
-- Table structure for qrtz_calendars
-- ----------------------------
DROP TABLE IF EXISTS `qrtz_calendars`;
CREATE TABLE `qrtz_calendars` (
  `SCHED_NAME` varchar(120) NOT NULL,
  `CALENDAR_NAME` varchar(200) NOT NULL,
  `CALENDAR` blob NOT NULL,
  PRIMARY KEY (`SCHED_NAME`,`CALENDAR_NAME`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of qrtz_calendars
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for qrtz_cron_triggers
-- ----------------------------
DROP TABLE IF EXISTS `qrtz_cron_triggers`;
CREATE TABLE `qrtz_cron_triggers` (
  `SCHED_NAME` varchar(120) NOT NULL,
  `TRIGGER_NAME` varchar(200) NOT NULL,
  `TRIGGER_GROUP` varchar(200) NOT NULL,
  `CRON_EXPRESSION` varchar(200) NOT NULL,
  `TIME_ZONE_ID` varchar(80) DEFAULT NULL,
  PRIMARY KEY (`SCHED_NAME`,`TRIGGER_NAME`,`TRIGGER_GROUP`),
  CONSTRAINT `qrtz_cron_triggers_ibfk_1` FOREIGN KEY (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) REFERENCES `qrtz_triggers` (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of qrtz_cron_triggers
-- ----------------------------
BEGIN;
INSERT INTO `qrtz_cron_triggers` VALUES ('adminQuartzScheduler', 'myTest', 'DEFAULT', '0/5 * * * * ?', 'Asia/Shanghai');
INSERT INTO `qrtz_cron_triggers` VALUES ('adminQuartzScheduler', '我的任务', 'DEFAULT', '0/6 * * * * ?', 'Asia/Shanghai');
COMMIT;

-- ----------------------------
-- Table structure for qrtz_fired_triggers
-- ----------------------------
DROP TABLE IF EXISTS `qrtz_fired_triggers`;
CREATE TABLE `qrtz_fired_triggers` (
  `SCHED_NAME` varchar(120) NOT NULL,
  `ENTRY_ID` varchar(95) NOT NULL,
  `TRIGGER_NAME` varchar(200) NOT NULL,
  `TRIGGER_GROUP` varchar(200) NOT NULL,
  `INSTANCE_NAME` varchar(200) NOT NULL,
  `FIRED_TIME` bigint(13) NOT NULL,
  `SCHED_TIME` bigint(13) NOT NULL,
  `PRIORITY` int(11) NOT NULL,
  `STATE` varchar(16) NOT NULL,
  `JOB_NAME` varchar(200) DEFAULT NULL,
  `JOB_GROUP` varchar(200) DEFAULT NULL,
  `IS_NONCONCURRENT` varchar(1) DEFAULT NULL,
  `REQUESTS_RECOVERY` varchar(1) DEFAULT NULL,
  PRIMARY KEY (`SCHED_NAME`,`ENTRY_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of qrtz_fired_triggers
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for qrtz_job_details
-- ----------------------------
DROP TABLE IF EXISTS `qrtz_job_details`;
CREATE TABLE `qrtz_job_details` (
  `SCHED_NAME` varchar(120) NOT NULL,
  `JOB_NAME` varchar(200) NOT NULL,
  `JOB_GROUP` varchar(200) NOT NULL,
  `DESCRIPTION` varchar(250) DEFAULT NULL,
  `JOB_CLASS_NAME` varchar(250) NOT NULL,
  `IS_DURABLE` varchar(1) NOT NULL,
  `IS_NONCONCURRENT` varchar(1) NOT NULL,
  `IS_UPDATE_DATA` varchar(1) NOT NULL,
  `REQUESTS_RECOVERY` varchar(1) NOT NULL,
  `JOB_DATA` blob,
  PRIMARY KEY (`SCHED_NAME`,`JOB_NAME`,`JOB_GROUP`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of qrtz_job_details
-- ----------------------------
BEGIN;
INSERT INTO `qrtz_job_details` VALUES ('adminQuartzScheduler', 'myTest', 'DEFAULT', 'myTest描述222', 'com.lvcoding.job.SpringBeanJob', '1', '0', '0', '0', 0xACED0005737200156F72672E71756172747A2E4A6F62446174614D61709FB083E8BFA9B0CB020000787200266F72672E71756172747A2E7574696C732E537472696E674B65794469727479466C61674D61708208E8C3FBC55D280200015A0013616C6C6F77735472616E7369656E74446174617872001D6F72672E71756172747A2E7574696C732E4469727479466C61674D617013E62EAD28760ACE0200025A000564697274794C00036D617074000F4C6A6176612F7574696C2F4D61703B787001737200116A6176612E7574696C2E486173684D61700507DAC1C31660D103000246000A6C6F6164466163746F724900097468726573686F6C6478703F4000000000000C7708000000100000000174000C4A4F425F444154415F4B45597372001A636F6D2E6C76636F64696E672E656E746974792E5379734A6F620CEB9C3BC2EABAC00200094C00086265616E4E616D657400124C6A6176612F6C616E672F537472696E673B4C000A63726561746554696D657400104C6A6176612F7574696C2F446174653B4C000463726F6E71007E00094C000B6465736372697074696F6E71007E00094C000269647400134C6A6176612F6C616E672F496E74656765723B4C00076A6F624E616D6571007E00094C000A6D6574686F644E616D6571007E00094C000673746174757371007E00094C000A75706461746554696D6571007E000A78707400086D795765624A6F627372000E6A6176612E7574696C2E44617465686A81014B59741903000078707708000001771E9577C07874000D302F35202A202A202A202A203F74000F6D7954657374E68F8FE8BFB0323232737200116A6176612E6C616E672E496E746567657212E2A0A4F781873802000149000576616C7565787200106A6176612E6C616E672E4E756D62657286AC951D0B94E08B0200007870000000117400066D795465737474000474657374740001317371007E000E7708000001771F203B30787800);
INSERT INTO `qrtz_job_details` VALUES ('adminQuartzScheduler', '我的任务', 'DEFAULT', '我的新任务', 'com.lvcoding.job.SpringBeanJob', '1', '0', '0', '0', 0xACED0005737200156F72672E71756172747A2E4A6F62446174614D61709FB083E8BFA9B0CB020000787200266F72672E71756172747A2E7574696C732E537472696E674B65794469727479466C61674D61708208E8C3FBC55D280200015A0013616C6C6F77735472616E7369656E74446174617872001D6F72672E71756172747A2E7574696C732E4469727479466C61674D617013E62EAD28760ACE0200025A000564697274794C00036D617074000F4C6A6176612F7574696C2F4D61703B787001737200116A6176612E7574696C2E486173684D61700507DAC1C31660D103000246000A6C6F6164466163746F724900097468726573686F6C6478703F4000000000000C7708000000100000000174000C4A4F425F444154415F4B45597372001A636F6D2E6C76636F64696E672E656E746974792E5379734A6F620CEB9C3BC2EABAC00200094C00086265616E4E616D657400124C6A6176612F6C616E672F537472696E673B4C000A63726561746554696D657400104C6A6176612F7574696C2F446174653B4C000463726F6E71007E00094C000B6465736372697074696F6E71007E00094C000269647400134C6A6176612F6C616E672F496E74656765723B4C00076A6F624E616D6571007E00094C000A6D6574686F644E616D6571007E00094C000673746174757371007E00094C000A75706461746554696D6571007E000A78707400086D795765624A6F627074000D302F36202A202A202A202A203F74000FE68891E79A84E696B0E4BBBBE58AA1737200116A6176612E6C616E672E496E746567657212E2A0A4F781873802000149000576616C7565787200106A6176612E6C616E672E4E756D62657286AC951D0B94E08B02000078700000001574000CE68891E79A84E4BBBBE58AA17400047465737474000131707800);
COMMIT;

-- ----------------------------
-- Table structure for qrtz_locks
-- ----------------------------
DROP TABLE IF EXISTS `qrtz_locks`;
CREATE TABLE `qrtz_locks` (
  `SCHED_NAME` varchar(120) NOT NULL,
  `LOCK_NAME` varchar(40) NOT NULL,
  PRIMARY KEY (`SCHED_NAME`,`LOCK_NAME`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of qrtz_locks
-- ----------------------------
BEGIN;
INSERT INTO `qrtz_locks` VALUES ('adminQuartzScheduler', 'STATE_ACCESS');
INSERT INTO `qrtz_locks` VALUES ('adminQuartzScheduler', 'TRIGGER_ACCESS');
COMMIT;

-- ----------------------------
-- Table structure for qrtz_paused_trigger_grps
-- ----------------------------
DROP TABLE IF EXISTS `qrtz_paused_trigger_grps`;
CREATE TABLE `qrtz_paused_trigger_grps` (
  `SCHED_NAME` varchar(120) NOT NULL,
  `TRIGGER_GROUP` varchar(200) NOT NULL,
  PRIMARY KEY (`SCHED_NAME`,`TRIGGER_GROUP`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of qrtz_paused_trigger_grps
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for qrtz_scheduler_state
-- ----------------------------
DROP TABLE IF EXISTS `qrtz_scheduler_state`;
CREATE TABLE `qrtz_scheduler_state` (
  `SCHED_NAME` varchar(120) NOT NULL,
  `INSTANCE_NAME` varchar(200) NOT NULL,
  `LAST_CHECKIN_TIME` bigint(13) NOT NULL,
  `CHECKIN_INTERVAL` bigint(13) NOT NULL,
  PRIMARY KEY (`SCHED_NAME`,`INSTANCE_NAME`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of qrtz_scheduler_state
-- ----------------------------
BEGIN;
INSERT INTO `qrtz_scheduler_state` VALUES ('adminQuartzScheduler', 'localhost1628771180602', 1628771765051, 10000);
COMMIT;

-- ----------------------------
-- Table structure for qrtz_simple_triggers
-- ----------------------------
DROP TABLE IF EXISTS `qrtz_simple_triggers`;
CREATE TABLE `qrtz_simple_triggers` (
  `SCHED_NAME` varchar(120) NOT NULL,
  `TRIGGER_NAME` varchar(200) NOT NULL,
  `TRIGGER_GROUP` varchar(200) NOT NULL,
  `REPEAT_COUNT` bigint(7) NOT NULL,
  `REPEAT_INTERVAL` bigint(12) NOT NULL,
  `TIMES_TRIGGERED` bigint(10) NOT NULL,
  PRIMARY KEY (`SCHED_NAME`,`TRIGGER_NAME`,`TRIGGER_GROUP`),
  CONSTRAINT `qrtz_simple_triggers_ibfk_1` FOREIGN KEY (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) REFERENCES `qrtz_triggers` (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of qrtz_simple_triggers
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for qrtz_simprop_triggers
-- ----------------------------
DROP TABLE IF EXISTS `qrtz_simprop_triggers`;
CREATE TABLE `qrtz_simprop_triggers` (
  `SCHED_NAME` varchar(120) NOT NULL,
  `TRIGGER_NAME` varchar(200) NOT NULL,
  `TRIGGER_GROUP` varchar(200) NOT NULL,
  `STR_PROP_1` varchar(512) DEFAULT NULL,
  `STR_PROP_2` varchar(512) DEFAULT NULL,
  `STR_PROP_3` varchar(512) DEFAULT NULL,
  `INT_PROP_1` int(11) DEFAULT NULL,
  `INT_PROP_2` int(11) DEFAULT NULL,
  `LONG_PROP_1` bigint(20) DEFAULT NULL,
  `LONG_PROP_2` bigint(20) DEFAULT NULL,
  `DEC_PROP_1` decimal(13,4) DEFAULT NULL,
  `DEC_PROP_2` decimal(13,4) DEFAULT NULL,
  `BOOL_PROP_1` varchar(1) DEFAULT NULL,
  `BOOL_PROP_2` varchar(1) DEFAULT NULL,
  PRIMARY KEY (`SCHED_NAME`,`TRIGGER_NAME`,`TRIGGER_GROUP`),
  CONSTRAINT `qrtz_simprop_triggers_ibfk_1` FOREIGN KEY (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) REFERENCES `qrtz_triggers` (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of qrtz_simprop_triggers
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for qrtz_triggers
-- ----------------------------
DROP TABLE IF EXISTS `qrtz_triggers`;
CREATE TABLE `qrtz_triggers` (
  `SCHED_NAME` varchar(120) NOT NULL,
  `TRIGGER_NAME` varchar(200) NOT NULL,
  `TRIGGER_GROUP` varchar(200) NOT NULL,
  `JOB_NAME` varchar(200) NOT NULL,
  `JOB_GROUP` varchar(200) NOT NULL,
  `DESCRIPTION` varchar(250) DEFAULT NULL,
  `NEXT_FIRE_TIME` bigint(13) DEFAULT NULL,
  `PREV_FIRE_TIME` bigint(13) DEFAULT NULL,
  `PRIORITY` int(11) DEFAULT NULL,
  `TRIGGER_STATE` varchar(16) NOT NULL,
  `TRIGGER_TYPE` varchar(8) NOT NULL,
  `START_TIME` bigint(13) NOT NULL,
  `END_TIME` bigint(13) DEFAULT NULL,
  `CALENDAR_NAME` varchar(200) DEFAULT NULL,
  `MISFIRE_INSTR` smallint(2) DEFAULT NULL,
  `JOB_DATA` blob,
  PRIMARY KEY (`SCHED_NAME`,`TRIGGER_NAME`,`TRIGGER_GROUP`),
  KEY `SCHED_NAME` (`SCHED_NAME`,`JOB_NAME`,`JOB_GROUP`),
  CONSTRAINT `qrtz_triggers_ibfk_1` FOREIGN KEY (`SCHED_NAME`, `JOB_NAME`, `JOB_GROUP`) REFERENCES `qrtz_job_details` (`SCHED_NAME`, `JOB_NAME`, `JOB_GROUP`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of qrtz_triggers
-- ----------------------------
BEGIN;
INSERT INTO `qrtz_triggers` VALUES ('adminQuartzScheduler', 'myTest', 'DEFAULT', 'myTest', 'DEFAULT', NULL, 1611217090000, 1611217085000, 5, 'PAUSED', 'CRON', 1611216673000, 0, NULL, 2, '');
INSERT INTO `qrtz_triggers` VALUES ('adminQuartzScheduler', '我的任务', 'DEFAULT', '我的任务', 'DEFAULT', NULL, 1628239944000, 1628239938000, 5, 'PAUSED', 'CRON', 1628239928000, 0, NULL, 2, '');
COMMIT;

-- ----------------------------
-- Table structure for sys_job
-- ----------------------------
DROP TABLE IF EXISTS `sys_job`;
CREATE TABLE `sys_job` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键id',
  `job_name` varchar(100) DEFAULT NULL COMMENT '任务名',
  `description` varchar(100) DEFAULT NULL COMMENT '任务描述',
  `cron` varchar(100) DEFAULT NULL COMMENT 'cron表达式',
  `bean_name` varchar(100) DEFAULT NULL COMMENT '任务执行时调用的spring的bean名称',
  `method_name` varchar(100) DEFAULT NULL COMMENT '任务方法名',
  `status` varchar(1) DEFAULT NULL COMMENT '任务状态（1运行中 2暂停中 3未启动)',
  `create_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` datetime DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=22 DEFAULT CHARSET=utf8mb4 COMMENT='quartz定时任务表';

-- ----------------------------
-- Records of sys_job
-- ----------------------------
BEGIN;
INSERT INTO `sys_job` VALUES (21, '我的任务', '我的新任务', '0/6 * * * * ?', 'myWebJob', 'test', '2', '2021-01-25 10:38:20', '2021-08-06 16:52:08');
COMMIT;

-- ----------------------------
-- Table structure for sys_log
-- ----------------------------
DROP TABLE IF EXISTS `sys_log`;
CREATE TABLE `sys_log` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键id',
  `type` varchar(1) DEFAULT NULL COMMENT '日志类型 1:用户日志 2菜单日志 3角色日志',
  `title` varchar(30) DEFAULT NULL COMMENT '日志标题',
  `ip` varchar(30) DEFAULT NULL COMMENT '操作ip地址',
  `addr` varchar(25) DEFAULT NULL COMMENT '操作地址',
  `request_uri` varchar(30) DEFAULT NULL COMMENT '请求uri',
  `method` varchar(10) DEFAULT NULL COMMENT '请求方式(POST,GET,PUT,DELETE)',
  `params` varchar(500) DEFAULT NULL COMMENT '请求提交参数',
  `time` bigint(20) DEFAULT NULL COMMENT '请求时间',
  `response` text COMMENT '响应数据',
  `create_by` varchar(20) DEFAULT NULL COMMENT '操作人',
  `create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  `del_flag` int(1) DEFAULT '0' COMMENT '是否删除,1已删0未删',
  `tenant_id` int(11) DEFAULT '1' COMMENT '租户id',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1649 DEFAULT CHARSET=utf8 COMMENT='系统日志表';

-- ----------------------------
-- Records of sys_log
-- ----------------------------
BEGIN;
INSERT INTO `sys_log` VALUES (1598, '1', 'admin用户登录', '127.0.0.1', '内网IP', '/certification', 'POST', 'username=%5Badmin%5D&password=%5B123456%5D', NULL, NULL, 'admin', '2021-08-12 09:14:26', '2021-08-12 09:14:26', 0, 1);
INSERT INTO `sys_log` VALUES (1599, '1', 'admin用户退出系统', '127.0.0.1', '内网IP', '/signout', 'GET', '', NULL, NULL, NULL, '2021-08-12 09:36:36', '2021-08-12 09:36:36', 0, 1);
INSERT INTO `sys_log` VALUES (1600, '1', 'zhangsan用户登录', '127.0.0.1', '内网IP', '/certification', 'POST', 'username=%5Bzhangsan%5D&password=%5B123456%5D', NULL, NULL, 'zhangsan', '2021-08-12 09:36:51', '2021-08-12 09:36:51', 0, 1);
INSERT INTO `sys_log` VALUES (1601, '1', 'zhangsan用户退出系统', '127.0.0.1', '内网IP', '/signout', 'GET', '', NULL, NULL, NULL, '2021-08-12 09:37:20', '2021-08-12 09:37:20', 0, 1);
INSERT INTO `sys_log` VALUES (1602, '1', 'admin用户登录', '127.0.0.1', '内网IP', '/certification', 'POST', 'username=%5Badmin%5D&password=%5B123456%5D', NULL, NULL, 'admin', '2021-08-12 09:37:22', '2021-08-12 09:37:22', 0, 1);
INSERT INTO `sys_log` VALUES (1603, '1', 'admin用户登录', '127.0.0.1', '内网IP', '/certification', 'POST', 'username=%5Badmin%5D&password=%5B123456%5D', NULL, NULL, 'admin', '2021-08-12 14:25:52', '2021-08-12 14:25:52', 0, 1);
INSERT INTO `sys_log` VALUES (1604, '1', 'admin用户登录', '127.0.0.1', '内网IP', '/certification', 'POST', 'username=%5Badmin%5D&password=%5B123456%5D', NULL, NULL, 'admin', '2021-08-12 15:55:12', '2021-08-12 15:55:12', 0, 1);
INSERT INTO `sys_log` VALUES (1605, '1', 'zhangsan用户登录', '0:0:0:0:0:0:0:1', '山西省 太原市', '/certification', 'POST', 'username=%5Bzhangsan%5D&password=%5B123456%5D', NULL, NULL, 'zhangsan', '2021-08-12 16:53:19', '2021-08-12 16:53:19', 0, 1);
INSERT INTO `sys_log` VALUES (1606, '1', 'admin用户登录', '127.0.0.1', '内网IP', '/certification', 'POST', 'username=%5Badmin%5D&password=%5B123456%5D', NULL, NULL, 'admin', '2021-08-12 17:41:43', '2021-08-12 17:41:43', 0, 1);
INSERT INTO `sys_log` VALUES (1607, '1', '查询用户列表', '127.0.0.1', '内网IP', '/users/page', 'GET', 'size=%5B10%5D', 93, '{\"code\":0,\"msg\":\"请求成功\",\"data\":{\"records\":[{\"id\":1,\"orgId\":3,\"username\":\"sadmin\",\"email\":\"23xxx@qq.com\",\"phone\":\"18911483365\",\"avatar\":null,\"status\":true,\"sort\":1,\"createTime\":null,\"updateTime\":1604290229000,\"delFlag\":0},{\"id\":2,\"orgId\":null,\"username\":\"admin\",\"email\":\"22@qq.com\",\"phone\":\"189222222\",\"avatar\":null,\"status\":true,\"sort\":null,\"createTime\":null,\"updateTime\":1604298484000,\"delFlag\":null},{\"id\":9,\"orgId\":3,\"username\":\"zhangsan\",\"email\":\"wuyanshen2012@hotmail.com\",\"phone\":\"18888888888\",\"avatar\":null,\"status\":true,\"sort\":null,\"createTime\":1627739824000,\"updateTime\":1627739824000,\"delFlag\":0},{\"id\":10,\"orgId\":2,\"username\":\"jl\",\"email\":\"wuyanshen2012@hotmail.com\",\"phone\":\"18888888888\",\"avatar\":null,\"status\":true,\"sort\":null,\"createTime\":1627739902000,\"updateTime\":1627739902000,\"delFlag\":0}],\"total\":4,\"size\":10,\"current\":1,\"orders\":[],\"optimizeCountSql\":true,\"hitCount\":false,\"searchCount\":true,\"pages\":1}}', 'admin', '2021-08-12 17:41:49', '2021-08-12 17:41:49', 0, 1);
INSERT INTO `sys_log` VALUES (1608, '3', '查询角色', '127.0.0.1', '内网IP', '/roles/page', 'GET', 'size=%5B5%5D', 65, '{\"code\":0,\"msg\":\"请求成功\",\"data\":{\"records\":[{\"id\":1,\"roleName\":\"管理员\",\"roleCode\":\"admin\",\"sort\":1,\"status\":1,\"updateTime\":1591860704000,\"createTime\":1584981146000,\"delFlag\":0},{\"id\":2,\"roleName\":\"普通用户\",\"roleCode\":\"common\",\"sort\":2,\"status\":1,\"updateTime\":1591693579000,\"createTime\":1584981195000,\"delFlag\":0}],\"total\":2,\"size\":5,\"current\":1,\"orders\":[],\"optimizeCountSql\":true,\"hitCount\":false,\"searchCount\":true,\"pages\":1}}', 'admin', '2021-08-12 17:41:50', '2021-08-12 17:41:50', 0, 1);
INSERT INTO `sys_log` VALUES (1609, '2', '查询菜单', '127.0.0.1', '内网IP', '/menus/treePage', 'GET', '', 56, '{\"code\":0,\"msg\":\"请求成功\",\"data\":[{\"id\":1,\"parentId\":0,\"children\":[{\"id\":2,\"parentId\":1,\"children\":[{\"id\":7,\"parentId\":2,\"children\":[],\"menuName\":\"用户查询\",\"url\":\"\",\"permission\":\"sys:user:view\",\"type\":\"1\",\"component\":null,\"keepAlive\":null,\"icon\":null,\"status\":1,\"sort\":null},{\"id\":8,\"parentId\":2,\"children\":[],\"menuName\":\"用户新增\",\"url\":\"\",\"permission\":\"sys:user:add\",\"type\":\"1\",\"component\":null,\"keepAlive\":null,\"icon\":null,\"status\":1,\"sort\":null},{\"id\":14,\"parentId\":2,\"children\":[],\"menuName\":\"更新用户\",\"url\":\"\",\"permission\":\"sys:user:update\",\"type\":\"1\",\"component\":null,\"keepAlive\":null,\"icon\":\"\",\"status\":1,\"sort\":null},{\"id\":34,\"parentId\":2,\"children\":[],\"menuName\":\"用户删除\",\"url\":\"\",\"permission\":\"sys:user:delete\",\"type\":\"1\",\"component\":null,\"keepAlive\":null,\"icon\":\"\",\"status\":null,\"sort\":null}],\"menuName\":\"用户管理\",\"url\":\"/user\",\"permission\":\"\",\"type\":\"0\",\"component\":null,\"keepAlive\":null,\"icon\":\"el-icon-user\",\"status\":1,\"sort\":1},{\"id\":9,\"parentId\":1,\"children\":[{\"id\":16,\"parentId\":9,\"children\":[],\"menuName\":\"菜单查询\",\"url\":null,\"permission\":\"sys:menu:view\",\"type\":\"1\",\"component\":null,\"keepAlive\":null,\"icon\":null,\"status\":1,\"sort\":null},{\"id\":18,\"parentId\":9,\"children\":[],\"menuName\":\"菜单新增\",\"url\":null,\"permission\":\"sys:menu:add\",\"type\":\"1\",\"component\":null,\"keepAlive\":null,\"icon\":null,\"status\":1,\"sort\":null},{\"id\":21,\"parentId\":9,\"children\":[],\"menuName\":\"菜单修改\",\"url\":\"\",\"permission\":\"sys:menu:update\",\"type\":\"1\",\"component\":null,\"keepAlive\":null,\"icon\":\"\",\"status\":1,\"sort\":null},{\"id\":22,\"parentId\":9,\"children\":[],\"menuName\":\"菜单删除\",\"url\":\"\",\"permission\":\"sys:menu:delete\",\"type\":\"1\",\"component\":null,\"keepAlive\":null,\"icon\":\"\",\"status\":1,\"sort\":null}],\"menuName\":\"菜单管理\",\"url\":\"/menu\",\"permission\":null,\"type\":\"0\",\"component\":null,\"keepAlive\":null,\"icon\":\"el-icon-menu\",\"status\":1,\"sort\":5},{\"id\":29,\"parentId\":1,\"children\":[{\"id\":30,\"parentId\":29,\"children\":[],\"menuName\":\"角色查询\",\"url\":\"\",\"permission\":\"sys:role:view\",\"type\":\"1\",\"component\":null,\"keepAlive\":null,\"icon\":\"\",\"status\":null,\"sort\":null},{\"id\":31,\"parentId\":29,\"children\":[],\"menuName\":\"角色修改\",\"url\":\"\",\"permission\":\"sys:role:update\",\"type\":\"1\",\"component\":null,\"keepAlive\":null,\"icon\":\"\",\"status\":null,\"sort\":null},{\"id\":32,\"parentId\":29,\"children\":[],\"menuName\":\"角色删除\",\"url\":\"\",\"permission\":\"sys:role:delete\",\"type\":\"1\",\"component\":null,\"keepAlive\":null,\"icon\":\"\",\"status\":null,\"sort\":null},{\"id\":33,\"parentId\":29,\"children\":[],\"menuName\":\"角色新增\",\"url\":\"\",\"permission\":\"sys:role:add\",\"type\":\"1\",\"component\":null,\"keepAlive\":null,\"icon\":\"\",\"status\":null,\"sort\":null},{\"id\":35,\"parentId\":29,\"children\":[],\"menuName\":\"分配权限\",\"url\":\"\",\"permission\":\"sys:permission:update\",\"type\":\"1\",\"component\":null,\"keepAlive\":null,\"icon\":\"\",\"status\":null,\"sort\":null}],\"menuName\":\"角色管理\",\"url\":\"/role\",\"permission\":\"\",\"type\":\"0\",\"component\":null,\"keepAlive\":null,\"icon\":\"el-icon-s-custom\",\"status\":null,\"sort\":null},{\"id\":39,\"parentId\":1,\"children\":[],\"menuName\":\"租户管理\",\"url\":\"/tenant\",\"permission\":\"\",\"type\":\"0\",\"component\":null,\"keepAlive\":null,\"icon\":\"el-icon-s-custom\",\"status\":1,\"sort\":null},{\"id\":41,\"parentId\":1,\"children\":[],\"menuName\":\"机构管理\",\"url\":\"/org\",\"permission\":\"\",\"type\":\"0\",\"component\":null,\"keepAlive\":null,\"icon\":\"el-icon-s-home\",\"status\":1,\"sort\":null}],\"menuName\":\"权限管理\",\"url\":\"/\",\"permission\":null,\"type\":\"0\",\"component\":null,\"keepAlive\":null,\"icon\":\"el-icon-setting\",\"status\":1,\"sort\":1},{\"id\":37,\"parentId\":0,\"children\":[],\"menuName\":\"百度\",\"url\":\"http://www.baidu.com\",\"permission\":\"\",\"type\":\"0\",\"component\":null,\"keepAlive\":null,\"icon\":\"el-icon-eleme\",\"status\":null,\"sort\":null},{\"id\":38,\"parentId\":0,\"children\":[],\"menuName\":\"腾讯网\",\"url\":\"http://qq.com\",\"permission\":\"\",\"type\":\"0\",\"component\":null,\"keepAlive\":null,\"icon\":\"el-icon-eleme\",\"status\":1,\"sort\":null},{\"id\":42,\"parentId\":0,\"children\":[{\"id\":3,\"parentId\":42,\"children\":[{\"id\":36,\"parentId\":3,\"children\":[],\"menuName\":\"日志查询\",\"url\":\"\",\"permission\":\"sys:log:view\",\"type\":\"1\",\"component\":null,\"keepAlive\":null,\"icon\":\"\",\"status\":null,\"sort\":null},{\"id\":84,\"parentId\":3,\"children\":[],\"menuName\":\"清空日志\",\"url\":null,\"permission\":\"sys:log:delete\",\"type\":\"1\",\"component\":null,\"keepAlive\":null,\"icon\":null,\"status\":1,\"sort\":null}],\"menuName\":\"系统日志\",\"url\":\"/log\",\"permission\":\"\",\"type\":\"0\",\"component\":null,\"keepAlive\":null,\"icon\":\"el-icon-tickets\",\"status\":1,\"sort\":2}],\"menuName\":\"系统监控\",\"url\":\"/monitor\",\"permission\":null,\"type\":\"0\",\"component\":null,\"keepAlive\":null,\"icon\":\"el-icon-monitor\",\"status\":1,\"sort\":null},{\"id\":43,\"parentId\":0,\"children\":[{\"id\":44,\"parentId\":43,\"children\":[{\"id\":47,\"parentId\":44,\"children\":[],\"menuName\":\"查询\",\"url\":null,\"permission\":\"sys:job:view\",\"type\":\"1\",\"component\":null,\"keepAlive\":null,\"icon\":null,\"status\":1,\"sort\":null},{\"id\":48,\"parentId\":44,\"children\":[],\"menuName\":\"修改/新增\",\"url\":null,\"permission\":\"sys:job:add\",\"type\":\"1\",\"component\":null,\"keepAlive\":null,\"icon\":null,\"status\":1,\"sort\":null},{\"id\":49,\"parentId\":44,\"children\":[],\"menuName\":\"删除任务\",\"url\":null,\"permission\":\"sys:job:delete\",\"type\":\"1\",\"component\":null,\"keepAlive\":null,\"icon\":null,\"status\":1,\"sort\":null},{\"id\":50,\"parentId\":44,\"children\":[],\"menuName\":\"手动执行一次任务\",\"url\":null,\"permission\":\"sys:job:trigger\",\"type\":\"1\",\"component\":null,\"keepAlive\":null,\"icon\":null,\"status\":1,\"sort\":null},{\"id\":51,\"parentId\":44,\"children\":[],\"menuName\":\"暂停任务\",\"url\":null,\"permission\":\"sys:job:pause\",\"type\":\"1\",\"component\":null,\"keepAlive\":null,\"icon\":null,\"status\":1,\"sort\":null},{\"id\":52,\"parentId\":44,\"children\":[],\"menuName\":\"恢复任务\",\"url\":null,\"permission\":\"sys:job:resume\",\"type\":\"1\",\"component\":null,\"keepAlive\":null,\"icon\":null,\"status\":1,\"sort\":null}],\"menuName\":\"任务管理\",\"url\":\"/job\",\"permission\":null,\"type\":\"0\",\"component\":null,\"keepAlive\":null,\"icon\":\"el-icon-time\",\"status\":1,\"sort\":null},{\"id\":46,\"parentId\":43,\"children\":[],\"menuName\":\"代码生成\",\"url\":\"/gen\",\"permission\":null,\"type\":\"0\",\"component\":null,\"keepAlive\":null,\"icon\":\"el-icon-set-up\",\"status\":1,\"sort\":null}],\"menuName\":\"系统工具\",\"url\":\"\",\"permission\":null,\"type\":\"0\",\"component\":null,\"keepAlive\":null,\"icon\":\"el-icon-suitcase-1\",\"status\":1,\"sort\":null},{\"id\":53,\"parentId\":0,\"children\":[{\"id\":55,\"parentId\":53,\"children\":[],\"menuName\":\"我的待办\",\"url\":\"/myTask\",\"permission\":null,\"type\":\"0\",\"component\":null,\"keepAlive\":null,\"icon\":\"el-icon-time\",\"status\":1,\"sort\":null},{\"id\":56,\"parentId\":53,\"children\":[],\"menuName\":\"请假\",\"url\":\"/leaveBill\",\"permission\":null,\"type\":\"0\",\"component\":null,\"keepAlive\":null,\"icon\":\"el-icon-finished\",\"status\":1,\"sort\":null},{\"id\":57,\"parentId\":53,\"children\":[],\"menuName\":\"流程管理\",\"url\":\"/actManage\",\"permission\":null,\"type\":\"0\",\"component\":null,\"keepAlive\":null,\"icon\":\"el-icon-s-marketing\",\"status\":1,\"sort\":null}],\"menuName\":\"OA管理\",\"url\":\"\",\"permission\":null,\"type\":\"0\",\"component\":null,\"keepAlive\":null,\"icon\":\"el-icon-s-help\",\"status\":1,\"sort\":null}]}', 'admin', '2021-08-12 17:41:53', '2021-08-12 17:41:53', 0, 1);
INSERT INTO `sys_log` VALUES (1610, '1', 'admin用户退出系统', '127.0.0.1', '内网IP', '/signout', 'GET', '', NULL, NULL, NULL, '2021-08-12 17:48:42', '2021-08-12 17:48:42', 0, 1);
INSERT INTO `sys_log` VALUES (1611, '1', 'admin用户登录', '127.0.0.1', '内网IP', '/certification', 'POST', 'username=%5Badmin%5D&password=%5B123456%5D', NULL, NULL, 'admin', '2021-08-12 17:48:45', '2021-08-12 17:48:45', 0, 1);
INSERT INTO `sys_log` VALUES (1612, '1', 'admin用户退出系统', '127.0.0.1', '内网IP', '/signout', 'GET', '', NULL, NULL, NULL, '2021-08-12 17:48:51', '2021-08-12 17:48:51', 0, 1);
INSERT INTO `sys_log` VALUES (1613, '1', 'admin用户登录', '127.0.0.1', '内网IP', '/certification', 'POST', 'username=%5Badmin%5D&password=%5B123456%5D&uuid=%5B2bcb0f82d8284ea5be42eb68f081894d%5D', NULL, NULL, 'admin', '2021-08-12 18:46:18', '2021-08-12 18:46:18', 0, 1);
INSERT INTO `sys_log` VALUES (1614, '1', 'zhangsan用户登录', '0:0:0:0:0:0:0:1', '山西省 太原市', '/certification', 'POST', 'username=%5Bzhangsan%5D&password=%5B123456%5D', NULL, NULL, 'zhangsan', '2021-08-12 18:57:43', '2021-08-12 18:57:43', 0, 1);
INSERT INTO `sys_log` VALUES (1615, '1', 'zhangsan用户登录', '0:0:0:0:0:0:0:1', '山西省 太原市', '/certification', 'POST', 'username=%5Bzhangsan%5D&password=%5B123456%5D', NULL, NULL, 'zhangsan', '2021-08-12 19:06:31', '2021-08-12 19:06:31', 0, 1);
INSERT INTO `sys_log` VALUES (1616, '1', 'zhangsan用户登录', '0:0:0:0:0:0:0:1', '山西省 太原市', '/certification', 'POST', 'username=%5Bzhangsan%5D&password=%5B123456%5D', NULL, NULL, 'zhangsan', '2021-08-12 19:14:47', '2021-08-12 19:14:47', 0, 1);
INSERT INTO `sys_log` VALUES (1617, '1', 'zhangsan用户登录', '0:0:0:0:0:0:0:1', '山西省 太原市', '/certification', 'POST', 'username=%5Bzhangsan%5D&password=%5B123456%5D', NULL, NULL, 'zhangsan', '2021-08-12 19:14:49', '2021-08-12 19:14:49', 0, 1);
INSERT INTO `sys_log` VALUES (1618, '1', 'zhangsan用户登录', '0:0:0:0:0:0:0:1', '山西省 太原市', '/certification', 'POST', 'username=%5Bzhangsan%5D&password=%5B123456%5D', NULL, NULL, 'zhangsan', '2021-08-12 19:18:20', '2021-08-12 19:18:20', 0, 1);
INSERT INTO `sys_log` VALUES (1619, '1', 'zhangsan用户登录', '0:0:0:0:0:0:0:1', '山西省 太原市', '/certification', 'POST', 'username=%5Bzhangsan%5D&password=%5B123456%5D', NULL, NULL, 'zhangsan', '2021-08-12 19:19:47', '2021-08-12 19:19:47', 0, 1);
INSERT INTO `sys_log` VALUES (1620, '1', 'zhangsan用户登录', '0:0:0:0:0:0:0:1', '山西省 太原市', '/certification', 'POST', 'username=%5Bzhangsan%5D&password=%5B123456%5D', NULL, NULL, 'zhangsan', '2021-08-12 19:20:26', '2021-08-12 19:20:26', 0, 1);
INSERT INTO `sys_log` VALUES (1621, '1', 'admin用户登录', '127.0.0.1', '内网IP', '/certification', 'POST', 'username=%5Badmin%5D&password=%5B123456%5D&uuid=%5Bfa146952e87b4e45b5b5e67bc6cd7206%5D&captcha=%5B4%5D', NULL, NULL, 'admin', '2021-08-12 19:27:37', '2021-08-12 19:27:37', 0, 1);
INSERT INTO `sys_log` VALUES (1622, '1', 'admin用户退出系统', '127.0.0.1', '内网IP', '/signout', 'GET', '', NULL, NULL, NULL, '2021-08-12 19:27:45', '2021-08-12 19:27:45', 0, 1);
INSERT INTO `sys_log` VALUES (1623, '1', 'admin用户登录', '127.0.0.1', '内网IP', '/certification', 'POST', 'username=%5Badmin%5D&password=%5B123456%5D&uuid=%5B6a4b0133edb24a11973e553ec0de8a6c%5D&captcha=%5B1%5D', NULL, NULL, 'admin', '2021-08-12 19:27:49', '2021-08-12 19:27:49', 0, 1);
INSERT INTO `sys_log` VALUES (1624, '1', 'admin用户退出系统', '127.0.0.1', '内网IP', '/signout', 'GET', '', NULL, NULL, NULL, '2021-08-12 19:27:59', '2021-08-12 19:27:59', 0, 1);
INSERT INTO `sys_log` VALUES (1625, '1', 'admin用户登录', '127.0.0.1', '内网IP', '/certification', 'POST', 'username=%5Badmin%5D&password=%5B123456%5D&uuid=%5B7ee8730e21624d808f1638439457aa84%5D', NULL, NULL, 'admin', '2021-08-12 19:28:01', '2021-08-12 19:28:01', 0, 1);
INSERT INTO `sys_log` VALUES (1626, '1', 'zhangsan用户登录', '0:0:0:0:0:0:0:1', '内网IP', '/certification', 'POST', 'username=%5Bzhangsan%5D&password=%5B123456%5D', NULL, NULL, 'zhangsan', '2021-08-12 19:31:43', '2021-08-12 19:31:43', 0, 1);
INSERT INTO `sys_log` VALUES (1627, '1', 'zhangsan用户登录', '0:0:0:0:0:0:0:1', '内网IP', '/certification', 'POST', 'username=%5Bzhangsan%5D&password=%5B123456%5D', NULL, NULL, 'zhangsan', '2021-08-12 19:32:34', '2021-08-12 19:32:34', 0, 1);
INSERT INTO `sys_log` VALUES (1628, '1', 'zhangsan用户登录', '0:0:0:0:0:0:0:1', '内网IP', '/certification', 'POST', 'username=%5Bzhangsan%5D&password=%5B123456%5D', NULL, NULL, 'zhangsan', '2021-08-12 19:32:55', '2021-08-12 19:32:55', 0, 1);
INSERT INTO `sys_log` VALUES (1629, '1', 'zhangsan用户登录', '0:0:0:0:0:0:0:1', '内网IP', '/certification', 'POST', 'username=%5Bzhangsan%5D&password=%5B123456%5D', NULL, NULL, 'zhangsan', '2021-08-12 19:35:04', '2021-08-12 19:35:04', 0, 1);
INSERT INTO `sys_log` VALUES (1630, '1', 'zhangsan用户登录', '0:0:0:0:0:0:0:1', '内网IP', '/certification', 'POST', 'username=%5Bzhangsan%5D&password=%5B123456%5D', NULL, NULL, 'zhangsan', '2021-08-12 19:36:17', '2021-08-12 19:36:17', 0, 1);
INSERT INTO `sys_log` VALUES (1631, '1', 'admin用户登录', '192.168.0.105', '内网IP', '/certification', 'POST', 'username=%5Badmin%5D&password=%5B123456%5D&uuid=%5B7dce0d795941471a8aa8ef089a0ba292%5D', NULL, NULL, 'admin', '2021-08-12 19:37:36', '2021-08-12 19:37:36', 0, 1);
INSERT INTO `sys_log` VALUES (1632, '1', 'admin用户登录', '0:0:0:0:0:0:0:1', '内网IP', '/certification', 'POST', '', NULL, NULL, 'admin', '2021-08-12 19:39:46', '2021-08-12 19:39:46', 0, 1);
INSERT INTO `sys_log` VALUES (1633, '1', 'admin用户退出系统', '192.168.0.105', '内网IP', '/signout', 'GET', '', NULL, NULL, NULL, '2021-08-12 19:42:10', '2021-08-12 19:42:10', 0, 1);
INSERT INTO `sys_log` VALUES (1634, '1', 'admin用户登录', '192.168.0.105', '内网IP', '/certification', 'POST', '', NULL, NULL, 'admin', '2021-08-12 20:03:35', '2021-08-12 20:03:35', 0, 1);
INSERT INTO `sys_log` VALUES (1635, '1', '查询用户列表', '192.168.0.105', '内网IP', '/users/page', 'GET', 'size=%5B10%5D', 8, '{\"code\":0,\"msg\":\"请求成功\",\"data\":{\"records\":[{\"id\":1,\"orgId\":3,\"captcha\":null,\"uuid\":null,\"username\":\"sadmin\",\"email\":\"23xxx@qq.com\",\"phone\":\"18911483365\",\"avatar\":null,\"status\":true,\"sort\":1,\"createTime\":null,\"updateTime\":1604290229000,\"delFlag\":0},{\"id\":2,\"orgId\":null,\"captcha\":null,\"uuid\":null,\"username\":\"admin\",\"email\":\"22@qq.com\",\"phone\":\"189222222\",\"avatar\":null,\"status\":true,\"sort\":null,\"createTime\":null,\"updateTime\":1604298484000,\"delFlag\":null},{\"id\":9,\"orgId\":3,\"captcha\":null,\"uuid\":null,\"username\":\"zhangsan\",\"email\":\"wuyanshen2012@hotmail.com\",\"phone\":\"18888888888\",\"avatar\":null,\"status\":true,\"sort\":null,\"createTime\":1627739824000,\"updateTime\":1627739824000,\"delFlag\":0},{\"id\":10,\"orgId\":2,\"captcha\":null,\"uuid\":null,\"username\":\"jl\",\"email\":\"wuyanshen2012@hotmail.com\",\"phone\":\"18888888888\",\"avatar\":null,\"status\":true,\"sort\":null,\"createTime\":1627739902000,\"updateTime\":1627739902000,\"delFlag\":0}],\"total\":4,\"size\":10,\"current\":1,\"orders\":[],\"optimizeCountSql\":true,\"hitCount\":false,\"searchCount\":true,\"pages\":1}}', 'admin', '2021-08-12 20:03:59', '2021-08-12 20:03:59', 0, 1);
INSERT INTO `sys_log` VALUES (1636, '1', 'admin用户退出系统', '192.168.0.105', '内网IP', '/signout', 'GET', '', NULL, NULL, NULL, '2021-08-12 20:04:03', '2021-08-12 20:04:03', 0, 1);
INSERT INTO `sys_log` VALUES (1637, '1', 'admin用户登录', '192.168.0.105', '内网IP', '/certification', 'POST', '', NULL, NULL, 'admin', '2021-08-12 20:13:19', '2021-08-12 20:13:19', 0, 1);
INSERT INTO `sys_log` VALUES (1638, '1', 'admin用户退出系统', '192.168.0.105', '内网IP', '/signout', 'GET', '', NULL, NULL, NULL, '2021-08-12 20:13:23', '2021-08-12 20:13:23', 0, 1);
INSERT INTO `sys_log` VALUES (1639, '1', 'admin用户登录', '192.168.0.105', '内网IP', '/certification', 'POST', '', NULL, NULL, 'admin', '2021-08-12 20:27:14', '2021-08-12 20:27:14', 0, 1);
INSERT INTO `sys_log` VALUES (1640, '1', 'admin用户退出系统', '192.168.0.105', '内网IP', '/signout', 'GET', '', NULL, NULL, NULL, '2021-08-12 20:28:21', '2021-08-12 20:28:21', 0, 1);
INSERT INTO `sys_log` VALUES (1641, '1', 'admin用户登录', '192.168.0.105', '内网IP', '/certification', 'POST', '', NULL, NULL, 'admin', '2021-08-12 20:30:27', '2021-08-12 20:30:27', 0, 1);
INSERT INTO `sys_log` VALUES (1642, '1', 'admin用户退出系统', '192.168.0.105', '内网IP', '/signout', 'GET', '', NULL, NULL, NULL, '2021-08-12 20:32:18', '2021-08-12 20:32:18', 0, 1);
INSERT INTO `sys_log` VALUES (1643, '1', 'admin用户登录', '192.168.0.105', '内网IP', '/certification', 'POST', '', NULL, NULL, 'admin', '2021-08-12 20:32:29', '2021-08-12 20:32:29', 0, 1);
INSERT INTO `sys_log` VALUES (1644, '1', '查询用户列表', '192.168.0.105', '内网IP', '/users/page', 'GET', 'size=%5B10%5D', 26, '{\"code\":0,\"msg\":\"请求成功\",\"data\":{\"records\":[{\"id\":1,\"orgId\":3,\"captcha\":null,\"uuid\":null,\"username\":\"sadmin\",\"email\":\"23xxx@qq.com\",\"phone\":\"18911483365\",\"avatar\":null,\"status\":true,\"sort\":1,\"createTime\":null,\"updateTime\":1604290229000,\"delFlag\":0},{\"id\":2,\"orgId\":null,\"captcha\":null,\"uuid\":null,\"username\":\"admin\",\"email\":\"22@qq.com\",\"phone\":\"189222222\",\"avatar\":null,\"status\":true,\"sort\":null,\"createTime\":null,\"updateTime\":1604298484000,\"delFlag\":null},{\"id\":9,\"orgId\":3,\"captcha\":null,\"uuid\":null,\"username\":\"zhangsan\",\"email\":\"wuyanshen2012@hotmail.com\",\"phone\":\"18888888888\",\"avatar\":null,\"status\":true,\"sort\":null,\"createTime\":1627739824000,\"updateTime\":1627739824000,\"delFlag\":0},{\"id\":10,\"orgId\":2,\"captcha\":null,\"uuid\":null,\"username\":\"jl\",\"email\":\"wuyanshen2012@hotmail.com\",\"phone\":\"18888888888\",\"avatar\":null,\"status\":true,\"sort\":null,\"createTime\":1627739902000,\"updateTime\":1627739902000,\"delFlag\":0}],\"total\":4,\"size\":10,\"current\":1,\"orders\":[],\"optimizeCountSql\":true,\"hitCount\":false,\"searchCount\":true,\"pages\":1}}', 'admin', '2021-08-12 20:32:32', '2021-08-12 20:32:32', 0, 1);
INSERT INTO `sys_log` VALUES (1645, '2', '查询菜单', '192.168.0.105', '内网IP', '/menus/treePage', 'GET', '', 129, '{\"code\":0,\"msg\":\"请求成功\",\"data\":[{\"id\":1,\"parentId\":0,\"children\":[{\"id\":2,\"parentId\":1,\"children\":[{\"id\":7,\"parentId\":2,\"children\":[],\"menuName\":\"用户查询\",\"url\":\"\",\"permission\":\"sys:user:view\",\"type\":\"1\",\"component\":null,\"keepAlive\":null,\"icon\":null,\"status\":1,\"sort\":null},{\"id\":8,\"parentId\":2,\"children\":[],\"menuName\":\"用户新增\",\"url\":\"\",\"permission\":\"sys:user:add\",\"type\":\"1\",\"component\":null,\"keepAlive\":null,\"icon\":null,\"status\":1,\"sort\":null},{\"id\":14,\"parentId\":2,\"children\":[],\"menuName\":\"更新用户\",\"url\":\"\",\"permission\":\"sys:user:update\",\"type\":\"1\",\"component\":null,\"keepAlive\":null,\"icon\":\"\",\"status\":1,\"sort\":null},{\"id\":34,\"parentId\":2,\"children\":[],\"menuName\":\"用户删除\",\"url\":\"\",\"permission\":\"sys:user:delete\",\"type\":\"1\",\"component\":null,\"keepAlive\":null,\"icon\":\"\",\"status\":null,\"sort\":null}],\"menuName\":\"用户管理\",\"url\":\"/user\",\"permission\":\"\",\"type\":\"0\",\"component\":null,\"keepAlive\":null,\"icon\":\"el-icon-user\",\"status\":1,\"sort\":1},{\"id\":9,\"parentId\":1,\"children\":[{\"id\":16,\"parentId\":9,\"children\":[],\"menuName\":\"菜单查询\",\"url\":null,\"permission\":\"sys:menu:view\",\"type\":\"1\",\"component\":null,\"keepAlive\":null,\"icon\":null,\"status\":1,\"sort\":null},{\"id\":18,\"parentId\":9,\"children\":[],\"menuName\":\"菜单新增\",\"url\":null,\"permission\":\"sys:menu:add\",\"type\":\"1\",\"component\":null,\"keepAlive\":null,\"icon\":null,\"status\":1,\"sort\":null},{\"id\":21,\"parentId\":9,\"children\":[],\"menuName\":\"菜单修改\",\"url\":\"\",\"permission\":\"sys:menu:update\",\"type\":\"1\",\"component\":null,\"keepAlive\":null,\"icon\":\"\",\"status\":1,\"sort\":null},{\"id\":22,\"parentId\":9,\"children\":[],\"menuName\":\"菜单删除\",\"url\":\"\",\"permission\":\"sys:menu:delete\",\"type\":\"1\",\"component\":null,\"keepAlive\":null,\"icon\":\"\",\"status\":1,\"sort\":null}],\"menuName\":\"菜单管理\",\"url\":\"/menu\",\"permission\":null,\"type\":\"0\",\"component\":null,\"keepAlive\":null,\"icon\":\"el-icon-menu\",\"status\":1,\"sort\":5},{\"id\":29,\"parentId\":1,\"children\":[{\"id\":30,\"parentId\":29,\"children\":[],\"menuName\":\"角色查询\",\"url\":\"\",\"permission\":\"sys:role:view\",\"type\":\"1\",\"component\":null,\"keepAlive\":null,\"icon\":\"\",\"status\":null,\"sort\":null},{\"id\":31,\"parentId\":29,\"children\":[],\"menuName\":\"角色修改\",\"url\":\"\",\"permission\":\"sys:role:update\",\"type\":\"1\",\"component\":null,\"keepAlive\":null,\"icon\":\"\",\"status\":null,\"sort\":null},{\"id\":32,\"parentId\":29,\"children\":[],\"menuName\":\"角色删除\",\"url\":\"\",\"permission\":\"sys:role:delete\",\"type\":\"1\",\"component\":null,\"keepAlive\":null,\"icon\":\"\",\"status\":null,\"sort\":null},{\"id\":33,\"parentId\":29,\"children\":[],\"menuName\":\"角色新增\",\"url\":\"\",\"permission\":\"sys:role:add\",\"type\":\"1\",\"component\":null,\"keepAlive\":null,\"icon\":\"\",\"status\":null,\"sort\":null},{\"id\":35,\"parentId\":29,\"children\":[],\"menuName\":\"分配权限\",\"url\":\"\",\"permission\":\"sys:permission:update\",\"type\":\"1\",\"component\":null,\"keepAlive\":null,\"icon\":\"\",\"status\":null,\"sort\":null}],\"menuName\":\"角色管理\",\"url\":\"/role\",\"permission\":\"\",\"type\":\"0\",\"component\":null,\"keepAlive\":null,\"icon\":\"el-icon-s-custom\",\"status\":null,\"sort\":null},{\"id\":39,\"parentId\":1,\"children\":[],\"menuName\":\"租户管理\",\"url\":\"/tenant\",\"permission\":\"\",\"type\":\"0\",\"component\":null,\"keepAlive\":null,\"icon\":\"el-icon-s-custom\",\"status\":1,\"sort\":null},{\"id\":41,\"parentId\":1,\"children\":[],\"menuName\":\"机构管理\",\"url\":\"/org\",\"permission\":\"\",\"type\":\"0\",\"component\":null,\"keepAlive\":null,\"icon\":\"el-icon-s-home\",\"status\":1,\"sort\":null}],\"menuName\":\"权限管理\",\"url\":\"/\",\"permission\":null,\"type\":\"0\",\"component\":null,\"keepAlive\":null,\"icon\":\"el-icon-setting\",\"status\":1,\"sort\":1},{\"id\":37,\"parentId\":0,\"children\":[],\"menuName\":\"百度\",\"url\":\"http://www.baidu.com\",\"permission\":\"\",\"type\":\"0\",\"component\":null,\"keepAlive\":null,\"icon\":\"el-icon-eleme\",\"status\":null,\"sort\":null},{\"id\":38,\"parentId\":0,\"children\":[],\"menuName\":\"腾讯网\",\"url\":\"http://qq.com\",\"permission\":\"\",\"type\":\"0\",\"component\":null,\"keepAlive\":null,\"icon\":\"el-icon-eleme\",\"status\":1,\"sort\":null},{\"id\":42,\"parentId\":0,\"children\":[{\"id\":3,\"parentId\":42,\"children\":[{\"id\":36,\"parentId\":3,\"children\":[],\"menuName\":\"日志查询\",\"url\":\"\",\"permission\":\"sys:log:view\",\"type\":\"1\",\"component\":null,\"keepAlive\":null,\"icon\":\"\",\"status\":null,\"sort\":null},{\"id\":84,\"parentId\":3,\"children\":[],\"menuName\":\"清空日志\",\"url\":null,\"permission\":\"sys:log:delete\",\"type\":\"1\",\"component\":null,\"keepAlive\":null,\"icon\":null,\"status\":1,\"sort\":null}],\"menuName\":\"系统日志\",\"url\":\"/log\",\"permission\":\"\",\"type\":\"0\",\"component\":null,\"keepAlive\":null,\"icon\":\"el-icon-tickets\",\"status\":1,\"sort\":2}],\"menuName\":\"系统监控\",\"url\":\"/monitor\",\"permission\":null,\"type\":\"0\",\"component\":null,\"keepAlive\":null,\"icon\":\"el-icon-monitor\",\"status\":1,\"sort\":null},{\"id\":43,\"parentId\":0,\"children\":[{\"id\":44,\"parentId\":43,\"children\":[{\"id\":47,\"parentId\":44,\"children\":[],\"menuName\":\"查询\",\"url\":null,\"permission\":\"sys:job:view\",\"type\":\"1\",\"component\":null,\"keepAlive\":null,\"icon\":null,\"status\":1,\"sort\":null},{\"id\":48,\"parentId\":44,\"children\":[],\"menuName\":\"修改/新增\",\"url\":null,\"permission\":\"sys:job:add\",\"type\":\"1\",\"component\":null,\"keepAlive\":null,\"icon\":null,\"status\":1,\"sort\":null},{\"id\":49,\"parentId\":44,\"children\":[],\"menuName\":\"删除任务\",\"url\":null,\"permission\":\"sys:job:delete\",\"type\":\"1\",\"component\":null,\"keepAlive\":null,\"icon\":null,\"status\":1,\"sort\":null},{\"id\":50,\"parentId\":44,\"children\":[],\"menuName\":\"手动执行一次任务\",\"url\":null,\"permission\":\"sys:job:trigger\",\"type\":\"1\",\"component\":null,\"keepAlive\":null,\"icon\":null,\"status\":1,\"sort\":null},{\"id\":51,\"parentId\":44,\"children\":[],\"menuName\":\"暂停任务\",\"url\":null,\"permission\":\"sys:job:pause\",\"type\":\"1\",\"component\":null,\"keepAlive\":null,\"icon\":null,\"status\":1,\"sort\":null},{\"id\":52,\"parentId\":44,\"children\":[],\"menuName\":\"恢复任务\",\"url\":null,\"permission\":\"sys:job:resume\",\"type\":\"1\",\"component\":null,\"keepAlive\":null,\"icon\":null,\"status\":1,\"sort\":null}],\"menuName\":\"任务管理\",\"url\":\"/job\",\"permission\":null,\"type\":\"0\",\"component\":null,\"keepAlive\":null,\"icon\":\"el-icon-time\",\"status\":1,\"sort\":null},{\"id\":46,\"parentId\":43,\"children\":[],\"menuName\":\"代码生成\",\"url\":\"/gen\",\"permission\":null,\"type\":\"0\",\"component\":null,\"keepAlive\":null,\"icon\":\"el-icon-set-up\",\"status\":1,\"sort\":null}],\"menuName\":\"系统工具\",\"url\":\"\",\"permission\":null,\"type\":\"0\",\"component\":null,\"keepAlive\":null,\"icon\":\"el-icon-suitcase-1\",\"status\":1,\"sort\":null},{\"id\":53,\"parentId\":0,\"children\":[{\"id\":55,\"parentId\":53,\"children\":[],\"menuName\":\"我的待办\",\"url\":\"/myTask\",\"permission\":null,\"type\":\"0\",\"component\":null,\"keepAlive\":null,\"icon\":\"el-icon-time\",\"status\":1,\"sort\":null},{\"id\":56,\"parentId\":53,\"children\":[],\"menuName\":\"请假\",\"url\":\"/leaveBill\",\"permission\":null,\"type\":\"0\",\"component\":null,\"keepAlive\":null,\"icon\":\"el-icon-finished\",\"status\":1,\"sort\":null},{\"id\":57,\"parentId\":53,\"children\":[],\"menuName\":\"流程管理\",\"url\":\"/actManage\",\"permission\":null,\"type\":\"0\",\"component\":null,\"keepAlive\":null,\"icon\":\"el-icon-s-marketing\",\"status\":1,\"sort\":null}],\"menuName\":\"OA管理\",\"url\":\"\",\"permission\":null,\"type\":\"0\",\"component\":null,\"keepAlive\":null,\"icon\":\"el-icon-s-help\",\"status\":1,\"sort\":null}]}', 'admin', '2021-08-12 20:32:34', '2021-08-12 20:32:34', 0, 1);
INSERT INTO `sys_log` VALUES (1646, '3', '查询角色', '192.168.0.105', '内网IP', '/roles/page', 'GET', 'size=%5B5%5D', 13, '{\"code\":0,\"msg\":\"请求成功\",\"data\":{\"records\":[{\"id\":1,\"roleName\":\"管理员\",\"roleCode\":\"admin\",\"sort\":1,\"status\":1,\"updateTime\":1591860704000,\"createTime\":1584981146000,\"delFlag\":0},{\"id\":2,\"roleName\":\"普通用户\",\"roleCode\":\"common\",\"sort\":2,\"status\":1,\"updateTime\":1591693579000,\"createTime\":1584981195000,\"delFlag\":0}],\"total\":2,\"size\":5,\"current\":1,\"orders\":[],\"optimizeCountSql\":true,\"hitCount\":false,\"searchCount\":true,\"pages\":1}}', 'admin', '2021-08-12 20:32:35', '2021-08-12 20:32:35', 0, 1);
INSERT INTO `sys_log` VALUES (1647, '1', 'admin用户退出系统', '192.168.0.105', '内网IP', '/signout', 'GET', '', NULL, NULL, NULL, '2021-08-12 20:32:52', '2021-08-12 20:32:52', 0, 1);
INSERT INTO `sys_log` VALUES (1648, '1', 'admin用户登录', '192.168.0.105', '内网IP', '/certification', 'POST', '', NULL, NULL, 'admin', '2021-08-12 20:33:21', '2021-08-12 20:33:21', 0, 1);
COMMIT;

-- ----------------------------
-- Table structure for sys_menu
-- ----------------------------
DROP TABLE IF EXISTS `sys_menu`;
CREATE TABLE `sys_menu` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键id',
  `menu_pid` int(11) DEFAULT NULL COMMENT '父id',
  `menu_pids` varchar(64) DEFAULT NULL COMMENT '所有的父id',
  `menu_name` varchar(20) DEFAULT NULL COMMENT '菜单名称',
  `url` varchar(64) DEFAULT NULL COMMENT '菜单路径',
  `permission` varchar(64) DEFAULT NULL COMMENT '权限标识',
  `icon` varchar(20) DEFAULT NULL COMMENT '菜单图标',
  `component` varchar(20) DEFAULT NULL COMMENT 'VUE页面',
  `type` varchar(5) DEFAULT NULL COMMENT '菜单类型(0菜单1按钮)',
  `keep_alive` varchar(5) DEFAULT NULL COMMENT '路由缓冲(1开启0关闭)',
  `status` int(2) DEFAULT '1' COMMENT '状态,1可用0不可用',
  `sort` int(4) DEFAULT NULL COMMENT '排序',
  `create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  `del_flag` int(2) DEFAULT '0' COMMENT '是否删除,1已删0未删',
  `tenant_id` int(11) DEFAULT '1' COMMENT '租户id',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=85 DEFAULT CHARSET=utf8 COMMENT='菜单表';

-- ----------------------------
-- Records of sys_menu
-- ----------------------------
BEGIN;
INSERT INTO `sys_menu` VALUES (1, 0, '0', '权限管理', '/', NULL, 'el-icon-setting', NULL, '0', NULL, 1, 1, '2020-03-24 00:25:57', '2021-01-20 16:14:49', 0, 1);
INSERT INTO `sys_menu` VALUES (2, 1, '1', '用户管理', '/user', '', 'el-icon-user', NULL, '0', NULL, 1, 1, '2020-03-24 00:41:33', '2020-06-10 19:02:04', 0, 1);
INSERT INTO `sys_menu` VALUES (3, 42, '1', '系统日志', '/log', '', 'el-icon-tickets', NULL, '0', NULL, 1, 2, '2020-03-24 00:42:09', '2021-01-25 14:30:46', 0, 1);
INSERT INTO `sys_menu` VALUES (7, 2, '1,2', '用户查询', '', 'sys:user:view', NULL, NULL, '1', NULL, 1, NULL, '2020-03-24 16:24:46', '2020-06-12 11:18:57', 0, 1);
INSERT INTO `sys_menu` VALUES (8, 2, '1,2', '用户新增', '', 'sys:user:add', NULL, NULL, '1', NULL, 1, NULL, '2020-03-28 01:58:00', '2020-04-12 19:34:03', 0, 1);
INSERT INTO `sys_menu` VALUES (9, 1, '1', '菜单管理', '/menu', NULL, 'el-icon-menu', NULL, '0', NULL, 1, 5, '2020-03-30 17:27:06', '2020-04-13 17:44:24', 0, 1);
INSERT INTO `sys_menu` VALUES (14, 2, NULL, '更新用户', '', 'sys:user:update', '', NULL, '1', NULL, 1, NULL, NULL, '2020-06-08 17:47:36', NULL, 1);
INSERT INTO `sys_menu` VALUES (16, 9, NULL, '菜单查询', NULL, 'sys:menu:view', NULL, NULL, '1', NULL, 1, NULL, '2020-06-08 16:50:32', '2020-06-08 16:50:32', 0, 1);
INSERT INTO `sys_menu` VALUES (18, 9, NULL, '菜单新增', NULL, 'sys:menu:add', NULL, NULL, '1', NULL, 1, NULL, '2020-06-08 16:56:22', '2020-06-08 16:56:22', 0, 1);
INSERT INTO `sys_menu` VALUES (21, 9, NULL, '菜单修改', '', 'sys:menu:update', '', NULL, '1', NULL, 1, NULL, NULL, '2020-06-08 17:37:05', NULL, 1);
INSERT INTO `sys_menu` VALUES (22, 9, NULL, '菜单删除', '', 'sys:menu:delete', '', NULL, '1', NULL, 1, NULL, NULL, '2020-06-08 18:03:20', NULL, 1);
INSERT INTO `sys_menu` VALUES (29, 1, NULL, '角色管理', '/role', '', 'el-icon-s-custom', NULL, '0', NULL, NULL, NULL, NULL, '2020-06-10 09:44:32', NULL, 1);
INSERT INTO `sys_menu` VALUES (30, 29, NULL, '角色查询', '', 'sys:role:view', '', NULL, '1', NULL, NULL, NULL, NULL, '2020-06-10 09:44:33', NULL, 1);
INSERT INTO `sys_menu` VALUES (31, 29, NULL, '角色修改', '', 'sys:role:update', '', NULL, '1', NULL, NULL, NULL, NULL, '2020-06-10 09:44:34', NULL, 1);
INSERT INTO `sys_menu` VALUES (32, 29, NULL, '角色删除', '', 'sys:role:delete', '', NULL, '1', NULL, NULL, NULL, NULL, '2020-06-10 09:44:35', NULL, 1);
INSERT INTO `sys_menu` VALUES (33, 29, NULL, '角色新增', '', 'sys:role:add', '', NULL, '1', NULL, NULL, NULL, NULL, '2020-06-10 09:44:36', NULL, 1);
INSERT INTO `sys_menu` VALUES (34, 2, NULL, '用户删除', '', 'sys:user:delete', '', NULL, '1', NULL, NULL, NULL, NULL, NULL, NULL, 1);
INSERT INTO `sys_menu` VALUES (35, 29, NULL, '分配权限', '', 'sys:permission:update', '', NULL, '1', NULL, NULL, NULL, NULL, NULL, NULL, 1);
INSERT INTO `sys_menu` VALUES (36, 3, NULL, '日志查询', '', 'sys:log:view', '', NULL, '1', NULL, NULL, NULL, NULL, NULL, NULL, 1);
INSERT INTO `sys_menu` VALUES (37, 0, NULL, '百度', 'http://www.baidu.com', '', 'el-icon-eleme', NULL, '0', NULL, NULL, NULL, NULL, '2021-01-25 14:25:31', NULL, 1);
INSERT INTO `sys_menu` VALUES (38, 0, NULL, '腾讯网', 'http://qq.com', '', 'el-icon-eleme', NULL, '0', NULL, 1, NULL, '2020-06-12 11:19:50', '2021-01-25 14:25:51', 0, 1);
INSERT INTO `sys_menu` VALUES (39, 1, '1', '租户管理', '/tenant', '', 'el-icon-s-custom', NULL, '0', NULL, 1, NULL, '2020-09-02 16:26:38', '2020-09-02 16:26:52', 0, 1);
INSERT INTO `sys_menu` VALUES (41, 1, '1', '机构管理', '/org', '', 'el-icon-s-home', NULL, '0', NULL, 1, NULL, '2020-11-05 14:46:26', '2020-11-05 14:55:54', 0, 1);
INSERT INTO `sys_menu` VALUES (42, 0, NULL, '系统监控', '/monitor', NULL, 'el-icon-monitor', NULL, '0', NULL, 1, NULL, '2021-01-20 16:07:46', '2021-01-25 14:29:26', 0, 1);
INSERT INTO `sys_menu` VALUES (43, 0, NULL, '系统工具', '', NULL, 'el-icon-suitcase-1', NULL, '0', NULL, 1, NULL, '2021-01-20 16:08:20', '2021-01-25 14:24:50', 0, 1);
INSERT INTO `sys_menu` VALUES (44, 43, NULL, '任务管理', '/job', NULL, 'el-icon-time', NULL, '0', NULL, 1, NULL, '2021-01-20 16:10:43', '2021-01-20 16:24:25', 0, 1);
INSERT INTO `sys_menu` VALUES (45, 45, NULL, '代码生成', NULL, NULL, NULL, NULL, '0', NULL, 1, NULL, '2021-01-20 16:15:29', '2021-01-20 16:15:35', 0, 1);
INSERT INTO `sys_menu` VALUES (46, 43, NULL, '代码生成', '/gen', NULL, 'el-icon-set-up', NULL, '0', NULL, 1, NULL, '2021-01-20 16:16:16', '2021-01-20 16:19:22', 0, 1);
INSERT INTO `sys_menu` VALUES (47, 44, NULL, '查询', NULL, 'sys:job:view', NULL, NULL, '1', NULL, 1, NULL, '2021-01-25 10:30:35', '2021-01-25 10:30:47', 0, 1);
INSERT INTO `sys_menu` VALUES (48, 44, NULL, '修改/新增', NULL, 'sys:job:add', NULL, NULL, '1', NULL, 1, NULL, '2021-01-25 10:31:35', '2021-01-25 10:31:46', 0, 1);
INSERT INTO `sys_menu` VALUES (49, 44, NULL, '删除任务', NULL, 'sys:job:delete', NULL, NULL, '1', NULL, 1, NULL, '2021-01-25 10:32:11', '2021-01-25 10:32:17', 0, 1);
INSERT INTO `sys_menu` VALUES (50, 44, NULL, '手动执行一次任务', NULL, 'sys:job:trigger', NULL, NULL, '1', NULL, 1, NULL, '2021-01-25 10:32:46', '2021-01-25 10:32:54', 0, 1);
INSERT INTO `sys_menu` VALUES (51, 44, NULL, '暂停任务', NULL, 'sys:job:pause', NULL, NULL, '1', NULL, 1, NULL, '2021-01-25 10:33:17', '2021-01-25 10:33:26', 0, 1);
INSERT INTO `sys_menu` VALUES (52, 44, NULL, '恢复任务', NULL, 'sys:job:resume', NULL, NULL, '1', NULL, 1, NULL, '2021-01-25 10:33:51', '2021-01-25 10:34:00', 0, 1);
INSERT INTO `sys_menu` VALUES (53, 0, NULL, 'OA管理', '', NULL, 'el-icon-s-help', NULL, '0', NULL, 1, NULL, '2021-08-02 15:53:39', '2021-08-04 09:03:42', 0, 1);
INSERT INTO `sys_menu` VALUES (55, 53, NULL, '我的待办', '/myTask', NULL, 'el-icon-time', NULL, '0', NULL, 1, NULL, '2021-08-02 15:56:07', '2021-08-04 09:04:25', 0, 1);
INSERT INTO `sys_menu` VALUES (56, 53, NULL, '请假', '/leaveBill', NULL, 'el-icon-finished', NULL, '0', NULL, 1, NULL, '2021-08-02 15:57:10', '2021-08-04 09:04:55', 0, 1);
INSERT INTO `sys_menu` VALUES (57, 53, NULL, '流程管理', '/actManage', NULL, 'el-icon-s-marketing', NULL, '0', NULL, 1, NULL, '2021-08-03 15:33:54', '2021-08-03 15:34:01', 0, 1);
INSERT INTO `sys_menu` VALUES (84, 3, '1,3', '清空日志', NULL, 'sys:log:delete', NULL, NULL, '1', NULL, 1, NULL, '2021-08-03 16:55:45', '2021-08-03 16:55:45', 0, 1);
COMMIT;

-- ----------------------------
-- Table structure for sys_org
-- ----------------------------
DROP TABLE IF EXISTS `sys_org`;
CREATE TABLE `sys_org` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键id',
  `org_pid` int(11) DEFAULT NULL COMMENT '父节点id',
  `org_pids` varchar(20) DEFAULT NULL COMMENT '所有的父节点',
  `is_leaf` int(11) DEFAULT NULL COMMENT '是否叶子节点',
  `org_name` varchar(20) DEFAULT NULL COMMENT '组织机构名称',
  `address` varchar(64) DEFAULT NULL COMMENT '地址',
  `status` int(11) DEFAULT '1' COMMENT '状态,1启用0无效',
  `sort` int(11) DEFAULT NULL COMMENT '排序',
  `level` int(11) DEFAULT NULL COMMENT '菜单的层级',
  `create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  `del_flag` int(11) DEFAULT '0' COMMENT '是否删除,1已删0未删',
  `tenant_id` int(11) DEFAULT '1' COMMENT '租户id',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='组织机构表';

-- ----------------------------
-- Records of sys_org
-- ----------------------------
BEGIN;
INSERT INTO `sys_org` VALUES (1, 0, '0', 0, 'cup总部', '北京海淀', 1, 1, 1, '2020-03-24 00:34:37', '2020-11-05 14:52:09', 0, 1);
INSERT INTO `sys_org` VALUES (2, 1, '1', 0, '研发部', '北京海淀', 1, 1, 2, '2020-03-24 00:36:31', '2020-03-24 00:36:31', 0, 1);
INSERT INTO `sys_org` VALUES (3, 2, '1,2', 1, '研发一部', '北京海淀', 1, 1, 3, '2020-03-24 00:37:36', '2020-03-24 00:37:36', 0, 1);
INSERT INTO `sys_org` VALUES (4, 2, '1,2', 1, '研发二部', '北京海淀', 1, 2, 3, '2020-03-24 00:38:09', '2020-03-24 00:38:09', 0, 1);
INSERT INTO `sys_org` VALUES (5, 0, NULL, 1, '测试机构', '', 1, 0, 1, '2020-11-05 14:48:15', '2020-11-05 14:48:15', 0, 1);
INSERT INTO `sys_org` VALUES (6, 1, '1', 1, '业务部', '北京海淀', 1, 1, 2, '2020-11-05 14:52:36', '2020-11-05 14:52:36', 0, 1);
INSERT INTO `sys_org` VALUES (7, 1, '1', 1, '人事部', '', 1, 0, 2, '2021-07-31 16:30:29', '2021-07-31 16:30:29', 0, 1);
COMMIT;

-- ----------------------------
-- Table structure for sys_role
-- ----------------------------
DROP TABLE IF EXISTS `sys_role`;
CREATE TABLE `sys_role` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键id',
  `role_name` varchar(20) DEFAULT NULL COMMENT '角色名称',
  `role_code` varchar(20) DEFAULT NULL COMMENT '角色英文名称',
  `sort` int(11) DEFAULT NULL COMMENT '排序',
  `status` int(11) DEFAULT '1' COMMENT '状态,1可用0不可用',
  `update_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `del_flag` int(11) DEFAULT '0' COMMENT '是否删除,1已删0未删',
  `tenant_id` int(11) DEFAULT '1' COMMENT '租户id',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='角色表';

-- ----------------------------
-- Records of sys_role
-- ----------------------------
BEGIN;
INSERT INTO `sys_role` VALUES (1, '管理员', 'admin', 1, 1, '2020-06-11 15:31:44', '2020-03-24 00:32:26', 0, 1);
INSERT INTO `sys_role` VALUES (2, '普通用户', 'common', 2, 1, '2020-06-09 17:06:19', '2020-03-24 00:33:15', 0, 1);
COMMIT;

-- ----------------------------
-- Table structure for sys_role_menu
-- ----------------------------
DROP TABLE IF EXISTS `sys_role_menu`;
CREATE TABLE `sys_role_menu` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键id',
  `role_id` int(11) DEFAULT NULL COMMENT '角色id',
  `menu_id` int(11) DEFAULT NULL COMMENT '菜单id',
  `tenant_id` int(11) DEFAULT '1' COMMENT '租户id',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=1156 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='角色和菜单关联表';

-- ----------------------------
-- Records of sys_role_menu
-- ----------------------------
BEGIN;
INSERT INTO `sys_role_menu` VALUES (1110, 1, 1, 1);
INSERT INTO `sys_role_menu` VALUES (1111, 1, 2, 1);
INSERT INTO `sys_role_menu` VALUES (1112, 1, 7, 1);
INSERT INTO `sys_role_menu` VALUES (1113, 1, 8, 1);
INSERT INTO `sys_role_menu` VALUES (1114, 1, 14, 1);
INSERT INTO `sys_role_menu` VALUES (1115, 1, 34, 1);
INSERT INTO `sys_role_menu` VALUES (1116, 1, 9, 1);
INSERT INTO `sys_role_menu` VALUES (1117, 1, 16, 1);
INSERT INTO `sys_role_menu` VALUES (1118, 1, 18, 1);
INSERT INTO `sys_role_menu` VALUES (1119, 1, 21, 1);
INSERT INTO `sys_role_menu` VALUES (1120, 1, 22, 1);
INSERT INTO `sys_role_menu` VALUES (1121, 1, 29, 1);
INSERT INTO `sys_role_menu` VALUES (1122, 1, 30, 1);
INSERT INTO `sys_role_menu` VALUES (1123, 1, 31, 1);
INSERT INTO `sys_role_menu` VALUES (1124, 1, 32, 1);
INSERT INTO `sys_role_menu` VALUES (1125, 1, 33, 1);
INSERT INTO `sys_role_menu` VALUES (1126, 1, 35, 1);
INSERT INTO `sys_role_menu` VALUES (1127, 1, 39, 1);
INSERT INTO `sys_role_menu` VALUES (1128, 1, 41, 1);
INSERT INTO `sys_role_menu` VALUES (1129, 1, 42, 1);
INSERT INTO `sys_role_menu` VALUES (1130, 1, 3, 1);
INSERT INTO `sys_role_menu` VALUES (1131, 1, 36, 1);
INSERT INTO `sys_role_menu` VALUES (1132, 1, 84, 1);
INSERT INTO `sys_role_menu` VALUES (1133, 1, 44, 1);
INSERT INTO `sys_role_menu` VALUES (1134, 1, 47, 1);
INSERT INTO `sys_role_menu` VALUES (1135, 1, 48, 1);
INSERT INTO `sys_role_menu` VALUES (1136, 1, 49, 1);
INSERT INTO `sys_role_menu` VALUES (1137, 1, 50, 1);
INSERT INTO `sys_role_menu` VALUES (1138, 1, 51, 1);
INSERT INTO `sys_role_menu` VALUES (1139, 1, 52, 1);
INSERT INTO `sys_role_menu` VALUES (1140, 1, 53, 1);
INSERT INTO `sys_role_menu` VALUES (1141, 1, 55, 1);
INSERT INTO `sys_role_menu` VALUES (1142, 1, 56, 1);
INSERT INTO `sys_role_menu` VALUES (1143, 1, 57, 1);
INSERT INTO `sys_role_menu` VALUES (1144, 1, 43, 1);
INSERT INTO `sys_role_menu` VALUES (1145, 2, 7, 1);
INSERT INTO `sys_role_menu` VALUES (1146, 2, 42, 1);
INSERT INTO `sys_role_menu` VALUES (1147, 2, 3, 1);
INSERT INTO `sys_role_menu` VALUES (1148, 2, 36, 1);
INSERT INTO `sys_role_menu` VALUES (1149, 2, 84, 1);
INSERT INTO `sys_role_menu` VALUES (1150, 2, 53, 1);
INSERT INTO `sys_role_menu` VALUES (1151, 2, 55, 1);
INSERT INTO `sys_role_menu` VALUES (1152, 2, 56, 1);
INSERT INTO `sys_role_menu` VALUES (1153, 2, 57, 1);
INSERT INTO `sys_role_menu` VALUES (1154, 2, 1, 1);
INSERT INTO `sys_role_menu` VALUES (1155, 2, 2, 1);
COMMIT;

-- ----------------------------
-- Table structure for sys_tenant
-- ----------------------------
DROP TABLE IF EXISTS `sys_tenant`;
CREATE TABLE `sys_tenant` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键id',
  `tenant_id` int(11) DEFAULT NULL COMMENT '租户编号',
  `tenant_name` varchar(50) DEFAULT NULL COMMENT '租户名称',
  `remark` varchar(100) DEFAULT NULL COMMENT '备注信息',
  `create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '更新时间',
  `del_flag` char(1) DEFAULT '0' COMMENT '是否已删除(0:未删除1:已删除)',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='租户信息表';

-- ----------------------------
-- Records of sys_tenant
-- ----------------------------
BEGIN;
INSERT INTO `sys_tenant` VALUES (1, 1, '北京卡普公司', '一家科技公司', '2020-08-28 13:48:16', '2020-08-28 13:48:16', '0');
INSERT INTO `sys_tenant` VALUES (4, 2, '上海卡普公司', 'IT', '2020-09-03 10:45:31', '2020-09-03 10:45:31', '0');
COMMIT;

-- ----------------------------
-- Table structure for sys_user
-- ----------------------------
DROP TABLE IF EXISTS `sys_user`;
CREATE TABLE `sys_user` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键id',
  `org_id` int(11) DEFAULT NULL COMMENT '组织机构id',
  `username` varchar(10) DEFAULT NULL COMMENT '用户名',
  `password` varchar(200) DEFAULT NULL COMMENT '密码',
  `email` varchar(50) DEFAULT NULL COMMENT '邮箱',
  `phone` varchar(20) DEFAULT NULL COMMENT '电话',
  `avatar` varchar(50) DEFAULT NULL COMMENT '头像',
  `status` int(11) DEFAULT '1' COMMENT '状态,1可用0不可用',
  `sort` int(11) DEFAULT NULL COMMENT '排序',
  `is_admin` int(11) DEFAULT NULL COMMENT '是否是系统管理员',
  `create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  `del_flag` int(11) DEFAULT '0' COMMENT '是否删除,1已删0未删',
  `tenant_id` int(11) DEFAULT '1' COMMENT '租户id',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='用户表';

-- ----------------------------
-- Records of sys_user
-- ----------------------------
BEGIN;
INSERT INTO `sys_user` VALUES (1, 3, 'sadmin', '$2a$10$BqmyJhzbUTwAlW6JPQINZufIgEBVvUs/Go6CjDPXPiI3bvSOJrWaW', '23xxx@qq.com', '18911483365', NULL, 1, 1, 1, NULL, '2020-11-02 12:10:29', 0, NULL);
INSERT INTO `sys_user` VALUES (2, NULL, 'admin', '$2a$10$BqmyJhzbUTwAlW6JPQINZufIgEBVvUs/Go6CjDPXPiI3bvSOJrWaW', '22@qq.com', '189222222', NULL, 1, NULL, NULL, NULL, '2020-11-02 14:28:04', NULL, 2);
INSERT INTO `sys_user` VALUES (9, 3, 'zhangsan', '$2a$10$S2RG6iq4/LiwICRPpGqj1u4pVpAH19ePvmvCFzENlB7shi42HD1gy', 'wuyanshen2012@hotmail.com', '18888888888', NULL, 1, NULL, NULL, '2021-07-31 21:57:04', '2021-07-31 21:57:04', 0, 1);
INSERT INTO `sys_user` VALUES (10, 2, 'jl', '$2a$10$CoZfAEOqRICgZjvidZPtt.a.1LyS4f4FE9EN1n7FKyM6RKDxs7/WW', 'wuyanshen2012@hotmail.com', '18888888888', NULL, 1, NULL, NULL, '2021-07-31 21:58:22', '2021-07-31 21:58:22', 0, 1);
COMMIT;

-- ----------------------------
-- Table structure for sys_user_role
-- ----------------------------
DROP TABLE IF EXISTS `sys_user_role`;
CREATE TABLE `sys_user_role` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键id',
  `user_id` int(11) DEFAULT NULL COMMENT '用户id',
  `role_id` int(11) DEFAULT NULL COMMENT '角色id',
  `tenant_id` int(11) DEFAULT '1' COMMENT '租户id',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=41 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='用户和角色关联表';

-- ----------------------------
-- Records of sys_user_role
-- ----------------------------
BEGIN;
INSERT INTO `sys_user_role` VALUES (17, 1, 1, 1);
INSERT INTO `sys_user_role` VALUES (37, 8, 10, 1);
INSERT INTO `sys_user_role` VALUES (38, 2, 1, 1);
INSERT INTO `sys_user_role` VALUES (39, 9, 2, 1);
INSERT INTO `sys_user_role` VALUES (40, 10, 2, 1);
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
